restrict dimension in pivot table

[singhcv123]

As per attached table ....( Pivot table)

I want to show dimension KPI   K1 --> K4  in 1 table.

K5--> K7  in another pivot table and    K8-----K9 in another pivot table

please suggest how to restrict pivot table like this.

[tresesco]

Check this logic: Paging Implementation for Straight table

[Anil_Babu_Samineni]

Yes, You can use like below

If(FieldName, 'K1', 'K2','K3','K4',FieldName)

[sunny_talwar]

I think you forgot to add the Match function Anil

Dimension for 1st table (Remember to check 'Suppress When Value Is Null' on the dimension tab for this calculated dimension)

If(Match(Kpi, 'K1', 'K2', 'K3', 'K4'), Kpi)

you can follow the same logic for the other tables.

[singhcv123]

not working ......can you suggest any other mechanism to achieve the same.

[lakshmikandh]

If(Match(Filedname, 'K1', 'K2', 'K3', 'K4'), Filedname)

This should work, can you share expression you are using ?

[vinieme12]

why not in the expression using set analysis?

KPI = {'KP1','KP2','KP'}