customize Pivot table

[vengadeshpalani]

Hi all,

i have pivot table like below but i need to show extra one row with blue color based on Dim-3 how can i achieve this requirement?

Actual

what we need

please give some idea...

[sunny_talwar]

Check attached

[vengadeshpalani]

thanks, Sunny

i have face the following issue 

[sunny_talwar]

Uncheck 'Suppress Zero Value' on the presentation tab and see if that helps

[vengadeshpalani]

i made changes in following things

Dim3

=Pick(ExtraDim, if([FINANCIAL PLAN]<>'ZZZZZ',[FINANCIAL PLAN]), ' ')

Dim3 color

=If(ExtraDim = 2, LightBlue())

expression

Pick(ExtraDim, (if ([FINANCIAL PLAN] <>'ZZZZZ', SUM(AMOUNT),0)), 0)

expression color

=If(ExtraDim = 2, LightBlue())

sort

Only({1} ExtraDim)

[sunny_talwar]

Uncheck 'Suppress Zero Value' on the presentation tab and see if that helps

[vengadeshpalani]

Sunny,

i have Unchecked Suppress Zero Value, it does not work.

FYI -->  by default following selection will happen, when i clear all it's working fine.

[vengadeshpalani]

Sunny

Even i clear all selection but i facing the same issue (Suppress Zero Value Unchecked)

[sunny_talwar]

May be try this

Dim3

=Pick(Only({1} ExtraDim), if([FINANCIAL PLAN]<>'ZZZZZ',[FINANCIAL PLAN]), ' ')

Dim3 color

=If(Only({1} ExtraDim) = 2, LightBlue())

expression

Pick(Only({1} ExtraDim), (if ([FINANCIAL PLAN] <>'ZZZZZ', SUM(AMOUNT),0)), 0)

expression color

=If(Only({1} ExtraDim) = 2, LightBlue())

[vengadeshpalani]

Error In Calculated Dimension