Total in pivot table not working

[Cbhuvi27]

Hello All,

Hello all,

I'm using the following code to show the Total header, however it doesn't work in the Total header but works in the Straight table.

=Pick(Wildmatch((IF(Type='A',Test1,Test2)),'*HAL*','*PAL*'),
'Yes','No')

[TauseefKhan]

Hi @Cbhuvi27,
Pivot tables require explicit aggregation. The total row in a pivot table aggregates all the rows, and you need to ensure the expression can handle this.

Check with this:
=Pick(
WildMatch(
Aggr(
Only(IF(Type='A', Test1, Test2)),
Dimension1, Dimension2, ... // Replace Dimension1, Dimension2, etc. with your actual dimension names
),
'*HAL*',
'*PAL*'
),
'Yes',
'No'
)

**********Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.******** 

[Cbhuvi27]

its not working 🙂 . Basically what I gave is working in straight table

[eneny]

Select all rows and columns in the workbook then select format coulumns show all. Same thing happens to me when I goof up and set either a row height or a column width to 0 or hidden.