keep table header

[ericdelaqua]

Hello

I have a table I would like to display in a pivot table while keeping the headers when selections are made. as shown below when type filter is selected I want to filter on the types while still showing the category.

how should the measure be written or is there any script change required ?

[mtucholski]

Your source table should look like that:

[Category,Product,type,amount

Bikes,bmx,x,500

Cars,bmw,vt,80000]

and not like that:

[Category,type,amount

Bikes,,

Cars,,

bmx,x,500

bmw,vt,80000]