How to get FY values using filtering month

[Siti Aishah Md Nor]

Hi.

I have 2 KPI that is FY and Month. Both are reading filter of Country, Month and Category.

FY should be an average of a few months, but it is just reading the monthly chosen filter.

How can i make the calculation of FY using the filters available

Should i be usingLimit data using expression

Attached is a sample of my work.

Thank you

[Gaia Paolini]

I am not sure I understand your dxp. You have set up four different filtering schemes and three hierarchies.

 

Can you clarify the goal My tentative understanding:

 

- the FY KPI should show the average Value for the selected entire Fiscal Year but for the selected Region and Category.

 

- the second KPI should show the average Value for the selected Months and for the selected Region and Category.

 

 

[Siti Aishah Md Nor]

Yes your understanding is correct.

 

My goal is to use the filters available to get FY values coz it can work for Month base on month i choose but how can i use the same filter for FY (it will get the avg of all the month in that FY)

[Gaia Paolini]

I cannot see a way of doing it, unless you maintain two separate filtering schemes, one for the FY and one for the month, but then the user interface would appear odd. An easier solution would be to always show a cross table with the average value per fiscal year and the total always displayed. Probably doable via IronPython. What tools do you have to use (e.g. IronPython, TERR) and how big is the dataset