Team,
I have below requirement.
KPI (Annualised Rev)-sum(Revenue)/ no. of quarters.
No. of quaters should only change when user selects Year filter. Otherwise it should all quarters till when we have data availability.
I have a table,
Table A:
Year,KPI,Qtr_count
Table B:
Year, Account Name
When i use below set analysis,
(sum(TOTAL_REVENUE)/SUM( total <Year>{1<KPI_Check={'PMA'},Year = $::Year>}Qtr_Count))
This works fine in all cases except in Map.
Can you help me with this.
Note: In others charts user will pull, Year and KPI (Annualised Rev) then no. of qtrs should be year specific. for all other dimension it should be complete quaters.
