Forum Discussion
Table or Matrix Visual with Subcategory Only Applying to One Main Category
Hello,
I have devised two solutions both of them aren't perfectly what I want but they both serve the purpose and I hope this can help others. There are two approaches:
1. Drill Through2. Customizing the calculation
In the first method I simply placed a drill through button and a drill through page that only expanded on the city for local sales. I also limited the drill through button to only work if "Local" was chosen on the table and if nothing or anything else was chosen the button would be disabledThe second option is to alter my calculation and add a SELECTEDVALUE(City_D[City Name]) and if that appears blank then the calculation will also result in a blank value (embedded in my switch statement)
Either of these option gets me to present the data I want to but in two different ways
Hello,
I have devised two solutions both of them aren't perfectly what I want but they both serve the purpose and I hope this can help others. There are two approaches:
1. Drill Through
2. Customizing the calculation
In the first method I simply placed a drill through button and a drill through page that only expanded on the city for local sales. I also limited the drill through button to only work if "Local" was chosen on the table and if nothing or anything else was chosen the button would be disabled
The second option is to alter my calculation and add a SELECTEDVALUE(City_D[City Name]) and if that appears blank then the calculation will also result in a blank value (embedded in my switch statement)
Either of these option gets me to present the data I want to but in two different ways