Hiding Dimension for 1 Expression in Pivot Table

rileymd88 — Wed, 03 Aug 2016 10:55:10 GMT

Hi All,

I am trying to implement a pivot table where I can hide the dimension for Expression 3 only and not sure if it is possible.

What I want to create looks like this:

Vendor	Apr	May	Total	Apr	May	Total	Total
	Expression 1	Expression 1	Expression 1	Expression 2	Expression 2	Expression 2	Expression 3
Vendor 1
Vendor 2
Vendor 3
Vendor 4
Total

My Dimensions Are:

Vendor

Month

My Expressions Are:

Expression 1

Expression 2

Expression 3

In order to get the Total columns I simply checked the following boxes:

Presentation -> Vendor -> Show Partial Sums

Presentation -> Month -> Show Partial Sums

The only thing left to do is to show Expression 3, however when I add expression 3 it will show me the columns Apr, May and YTD. How can I make expression 3 show only the Total?

Thanks,

Riley

topic Hiding Dimension for 1 Expression in Pivot Table in QlikView

Hiding Dimension for 1 Expression in Pivot Table