Make first 3 dimensions fixed in pivot table while rest of data is dynamic

[#1]

Hi,

How do i fixed the first 3 columns of a pivot tables (which are dimension) where the rest can be filtered.

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6

For the example above, headers 1,2 and 3 will be fixed where else header 4, 5 and 6 depends on the selection.

Attached my dashboard where Case Logs is the tab to find this behavior.

Please kindly help on this.

Thanks

Chun Wey

[alexandros17]

In your expressions use an if condition like this (In the expression and in the label):

If(GetFieldSelections(myField)='Value1',

   Expression1,

   Expression2)

In the label

If(GetFieldSelections(myField)='Value1',

   Label1,

   Label2)

Let me know

[#3]

Hi Alessandro,

Thanks for helping in this.

Can kindly explain further on this?

Thanks

Chun Wey

[alexandros17]

This is my example

[#5]

Hi Alessandro,

Attached is my qvw, i still cannot solve.

Under Case Logs Tab, when I click on Tan Senior Resident, the table dis-align.  When clicking on John Lee, it works.

Thank you.

[alexandros17]

This is because there are no value linked

[#7]

Hi Alessandro,

If there are no value linked, it means there is no way for this.

So should i don show the resident that has no value linked at the start ? If yes, can advice how to go about this?

Thanks

Chun Wey