Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to implement Alternative States in a form of comparative analysis, however all the examples I can find are not quite what is required. They always seem to allow product vs product but what I want is product vs subset of product.
In other words what I'm looking for is two sets, one being the default selection set of the document (easy enough) - and the other being an alternative state set which is the default selection plus any further selections from a series of listboxes / multibox.
E.g:
using region / countries as an example - user picks 'Europe' from Region anywhere in the document and both chart A + B show Europe.
Region options of Africa, Americas, etc are not available to both the default and alternate charts.
User can then cycle view / drill down to country and pick UK in a list box. This will show in chart B while keeping all European countries in chart A.
Does anyone know if this is possible? Hope that example made sense!
I think you don't need alternate states but I should work on expressions and dimensions:
In your first table try to check "Show all Values"
I can imagine taht you have this camparision on one of your sheets.
If yes, you may:
1. copy selections from application into defined alternate state during sheet oppening (there is trigger for that).
2. user may do additional selections on that sheet in both states and investigate results.
regards
Darek
See attached sample. Expression like:
= sum({$+[st1]<Country =[st1]::Country>}Sales)
Hi
You could do it like this:
This will allow you to drill down to the country in the list box. Chart A will follow the region and Chart B will follow the drill down.
HTH
Jonathan