Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below data
Emp | Country | Region | Month | Sales |
Ram | India | APAC | Jan | 200 |
Raj | UK | Europe | Jan | 100 |
Ram | India | APAC | Feb | 300 |
Created a pivot table as below
APAC | ||
Emp | Jan | Feb |
Ram | 200 | 300 |
When clicking on APAC then need to show country values (dynamically) in same table
APAC | India | |||
Emp | Jan | Feb | Jan | Feb |
Ram | 200 | 300 | 200 | 300 |
Thanks In advance,
Priya
Create a drill down down group and use the drill down group in dimension.
HI Neelam
I need to display the column(India) dynamically when user selects on APAC
Thanks
Hi,
I have managed to show the expression dynamically using GetFieldSelections function.
But the requirement is to show below
Now the field Country contains only India as Region and if China is added later then instead of writing the expression manually for each region, can we write one expression that dynamically read the values from the field Region to form the expression for each region
Can this be done in UI or Load script?
Thanks ALL.
H All,
Any suggestion please?
Regards,
Priya
For the output like your last table, what I would do is - Use EMP and Country as dimension in a pivot table and use set analysis for 'APAC'. Something like Sum({<Region = {'APAC'}>}Sales).
it would be more helpful if you can share a sample qv file.
Check this out.
You can play play around the 'Total' display depending on how you want it.
You can also use the below expression if you are looking to make changes only for APAC-
=If(GetFieldSelections(Region)= 'APAC', 'APAC', 'TOTAL')
Thank you Neelam for the suggestion.
I agree with the expression if user select on APAC, below expression works.
=GetFieldSelections(Region)= 'APAC'
But Region Listbox has APAC, EUROPE, USA...and when user makes a selection on the Region ListBox(EUROPE/USA) then Pivot table has show the countries belongs to dynamically
I think a variable to read the user input may help. please suggest
Hi Priya,
Thanks exactly what is QVW is doing.
Can you specifically tell me whats not working in the attachment?
Thank you Neelam .
Finally i achieved the output