I have a drill down that has been created, now i want a KPI object to only display the value of the second selection. How can i achieve this. For instance, my drill-down has INDUSTRY - SECTOR, the user is to select an industry then a sector. But i just want the value of the sector to be displayed only.
Your expression Here))
Whenever a value from INDUSTRY field is selected, it would rather give you sum or count of Sector but if nothing is selected, the KPI would show null.
It would be helpful if you tell us what is your expression in KPI?
If(GetCurrentField([Group Name of Drill]) = 'SECTOR' or GetSelectedCount(INDUSTRY)=1, Measure)
|Company A||Financial Services||50|
|Company B||Consumer Goods||40|
|Company C||Consumer Goods||10|
My drill down is:
When a user clicks on the industry, it displays the names of companies in that industry. I want a KPI to display the value of Total for a company selected from the drill down not for the industry. !
From this, Can you explain in Case study like if Industry is filter from user is "Consumer Goods" What output you are expecting in text box?
i want a situation where if you click on [Consumer Goods], Company B and Company C will appear. Then the value on the KPI object will be the Total of either Company B (40) or Company C(10) based on the user's final selection.