Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created an actuals KPI and Pivot Table. I added a KPI fields. The user will see by all years. I select by year (2015). Then I see my KPI Dashboard and then select company. I want to see KPI fields Sum by that select year and another sum based on my selected selection (example Company).
In this case you need to use a set expression:
Sum({<Year={2015}> Sales} Sales for the Year 2015
Sum({<Year={$(=Max(Year))}> Sales} Sales for the selected Year
Sum({<Year={$(=Max(Year))}, Company_ID> Sales} Sales for the selected Year, no matter a selected company
etc...