Siti Aishah Md Nor Posted February 18, 2021 Share Posted February 18, 2021 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 Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 19, 2021 Share Posted February 19, 2021 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. Link to comment Share on other sites More sharing options...
Siti Aishah Md Nor Posted February 22, 2021 Author Share Posted February 22, 2021 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) Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 24, 2021 Share Posted February 24, 2021 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now