Filtering Value in Pivot table

[dsharmaqv]

Hi

I want to display the value >=500 in pivot table also i am displaying partial sum by column  A and B.

A	B	C	D	F	Balance
GBM	IND	EQ	Portfolio1	D1	555
GBM	IND	EQ	Portfolio2	D2	666
GBM	IND	EQ	Portfolio3	D3	777
GBM	IND	EQ	Portfolio4	D4	888
GBM	FX	US	Portfolio6	D5	999
GBM	FX	US	Portfolio5	D6	111

Can some one assist me to get the required result.

[millan123]

HI,

U can set the values in dimension limit tab there u can put >=500 then u will get

[fashid]

Check partial sums in presentation tab for the respective columns

[vikasmahajan]

you can implement Re: what if

Vikas

[HirisH_V7]

Hi,

May be like this,

If(Sum({<A={'GBM'},B={'IND','FX'}>}Sales)>500,
Sum({<A={'GBM'},B={'IND','FX'}>}Sales))


If(Your Expression >500,Your Expression)

HTH,

Hirish

[sunny_talwar]

Would you be able to share a sample to look at this? and also share what the expected output is?

[dsharmaqv]

A	B	C	D	F	Balance
GBM	IND	EQ	Portfolio1	D1	555
GBM	IND	EQ	Portfolio2	D2	666
GBM	IND	EQ	Portfolio3	D3	777
GBM	IND	EQ	Portfolio4	D4	888
	Total				2886
GBM	FX	US	Portfolio6	D5	999
	Total				999
Total					3885

Expected Output

[sunny_talwar · Accepted solution]

Have you tried this?

Dimension:

A

B

C

D

F

Expression

Sum(Aggr(If(Sum(Balance) >=500, Sum(Balance)), A, B, C, D, F))

[dsharmaqv]

Thanks Sunny....

[dsharmaqv]

Hi clark, Option is not available for pivot table