Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thank you
Put the expression that you are using in a text box and it will display the value.
For example
='The Value is ' & sum(Sales)
Maybe
If(Getselectedcount(INDUSTRY)=1,
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?
Perhaps this?
If(GetCurrentField([Group Name of Drill]) = 'SECTOR' or GetSelectedCount(INDUSTRY)=1, Measure)
Hi Abraham,
Like this ?
Or like this as suggested above:
Company Name | Industry | Total |
---|---|---|
Company A | Financial Services | 50 |
Company B | Consumer Goods | 40 |
Company C | Consumer Goods | 10 |
Company D | Entertainment | 20 |
My drill down is:
Industry
Company Name
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.