Hi,
I want to add some data to the dashboard only when the year value increases beyond 2011. I have created a calculated field to show that data.
However, the percentage value changes when trying to only show beyond a particular year using the formula below. I cannot understand why this is happening and how I can fix this. I am open to use other ways to achieve the desired goal.
Formula used:
IF [Year] > 2011
THEN
[PercentageOfHeroin]
END
PercentageOfHeroin:
{ FIXED [Drug],[Year]:SUM(If [Drug]="Heroin" THEN [Deaths (DeathsDrugType)] END)}
/{FIXED [Year]:SUM([Deaths (DeathsDrugType)])}
Attaching the workbook for reference. The concerned sheet is "Question"
Thanks In advance for your time and help.
I was able to achieve the goal after changing the field to attribute. But I still don't know why