Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to suppress a dimension (Month) in a Pivot Table so that it only displays for a specific expression.
Expressions Sales Purchases
Dimension - Month Jan. Feb. Mar. Total 'No Month Dimension to be displayed''
Amount 10 20 30 60 15
Any help would be appreciated.
Tony
For the secondary Dimension (say it's the field "Month"), instead use a Calculated Dimension:
if( [PrimaryDim] = 'Purchases', Null(), [Month] )
PrimaryDim is whatever the field for your first dimension.
Then you may want to set the Null Symbol to empty on the Presentation tab.
Hi Donald,
Thanks for the reply.
I'm trying to use your suggestion but without success.
Could you use the attached qvw to suggest a way.
Thanks
Tony
Sorry, I misunderstood your requirement.
I'm not sure you can effectively suppress a dimension in your chart for just one of your expressions. The expressions will be evaluated in the context of the dimensions.
You can vary the expression, of course. You can even vary the expression based on the context of its dimension. But neither will help you, here.
I suppose you could create a table just for your Purchases and park it right next to your Sales table.
Perhaps someone else will see somehting I'm missing here.