I am trying to achieve something like there are some hierarchies
like Category ----> Sub Category ---> Region
my requirement initially on my dashboard the graph shows category level data
if i select any category it has to be changed to sub category and it has to show sub category values if i return back and select all categories it has to show categories values
this is my requirement
Thanks in Advance.
I would create a FIXED LOD calculated field like this. Let's say you want the average sales.
If you manually calculate the average sales of Bookcases Regions, it should be 28720.
Then when you drill up to sub-category level, you should see that Bookcases is also 28720.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...