% for a field in a dimension with month selected in Pivot Chart.

[saumyashah90]

Hi Team,

I have a pivot chart where i have dragged months from rows to column. I have a month selected but in chart i want all the months where 1 of field i.e. "C" from the column i want to format in % others i.e. "A","B" in normal as it is.

Here you can see As october month is selected ,only october is seen in % format other are in normal for L1="C", Where as i expect all the values under C should have % value with October month selected.

Attached my sample application in 1st response.

[saumyashah90]

QVW for your reference

[Shubham_Deshmukh]

Have you tried if else combination?

[saumyashah90]

yup Already tried. I have attached my application on the 1st reply.

[sunny_talwar · Accepted solution]

Try this

If(Only({1}L1) = 'C',
Num(Sum({<MonthNum=>}Data),'#,##0.00%'),
Num(Sum({<MonthNum=>}Data),'#,##0.00'))