Level of Expansion in a Pivot Table

[joshabbott]

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!

[awhitfield]

HI Josh,

can you post an example qvw?

Andy

[Anonymous]

I don't think it's possible.  Even if it was - what to do if Name dimension is expanded only for one Course value?

[marcus_sommer]

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

[petter]

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),'')