Need help in pivot table

[#1]

Hi,

In a Pivot table how to control the dimention value for instance, I have a service type and the value is 1,2,3,4 and I would like to display only service type =1 in the pivot table.

is somebody can help.....

Regards

Joe

[maleksafa]

you need to filter it in your expression.

for example if your dimension is service type and let's assume that your expression is sum sales. then you need to modify your expression to be sum({<[service type]=1>}sales)

[ashfaq_haseeb · Accepted solution]

Hi

Try this in expression

sum({<[service type]=1>}sales)

Or Try this as Calculated dimension

if([service type]=1,[service type])

Click on suppress null values for Dimension

Expression would be

sum(sales)

Regards

ASHFAQ

[#4]

Hi,

use this

sum({[Service type]={1}>} Sales)

[#5]

Thanks Malek for your reply,

in the expression i have added  1 only, the data is already calculated, so just show the the Service type value 1 only.

[maleksafa]

i didn't get you very well, did it solve your problem or you are still facing the same challenge?

[#7]

Hi, this is works fine....

Thanks a lot for your support.

if([service type]=1,[service type])

Click on suppress null values for Dimension