Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm looking for a way to determine if a pivot table is showing the final column (fully expanded in a row). I have 4 dimensions in this pivot table:
Course
Division
Category
Name
I also have 2 expressions:
Training Date (which =max(Training Date))
Count of Students (count distinct Name)
If a user has expanded a pivot table to where they can see 'Name', I'd like to hide the second expression (Count of Students), because it just shows a bunch of 1's. Is this possible?
Thanks!
HI Josh,
can you post an example qvw?
Andy
I don't think it's possible. Even if it was - what to do if Name dimension is expanded only for one Course value?
It might be possible to query this per macro. But macros aren't recommended and won't work within a AJAX client. Therefore the answer is no. But maybe you could use another approaches to display your data. Maybe with dimension-groups or several chart-objects (within a container) with specialized sights and expressions or ...
- Marcus
You can remove the display of 1 if you have it drilled down to the individual student level by
having this expression:
If( Dimensionality()<4,Count(DISTINCT Name),'')