Pivot Table

[NavinReddy]

Dear All,

I created one Pivot table with one cycle group

its showing all business values but i want to show only 3 business only

=sum({<[New Level 1]=' Admin' or 'Ops' or 'Tech'>} [ Open Calls])

this expression not working

i want to filter These 3 only

where can i apply filters Group wise or Expression wise

Please guide me some one

Thanks In Advance

Niru

[MK_QSL]

SUM({<[New Level 1] = {'Admin','Ops','Tech'}>} [ Open Calls])

Or

Create a Calculated Dimension

IF([New Level 1] = 'Admin' or [New Level 1] = 'Ops' or [New Level 1] = 'Tech', [New Level 1])

Tick Suppress When Value is NULL

and Expression

SUM([Open Calls])

or

IF(Match([New Level 1], 'Admin','Ops','Tech'), [New Level 1])

Tick Suppress When Value is NULL

and Expression

SUM([Open Calls])

[PrashantSangle]

Hi,

try this

=sum({<[New Level 1]={' Admin ', 'Ops' ,' Tech'}>} [ Open Calls])

Regards,

PS

[NavinReddy]

Hi manish,

But i have cyclic group also

if it one field its working fine

but inside cycle group i have Three fields is there

If i select any field ,the 3 filters should apply

Regards,

Niru

[MK_QSL]

in this case, if you provide sample file would be great...

[PrashantSangle]

Hi,

Try Indirect Set Analysis.

P()

Regards,

[NavinReddy]

Hi,

sorry,this is client data i cant able to provide

where can i apply filter in Cycle Group or Expression

Thank you

Regards,

Niru

[MK_QSL]

You can definitely create a sample file having similar field name...

[MK_QSL]

If you have cyclic group as dimension,

use below in expression....this should work..

SUM({<[New Level 1] = {'Admin','Ops','Tech'}>} [ Open Calls])

[NavinReddy]

yes same, but expression not working