topic Re: Total in pivot table not working in App Development

Total in pivot table not working

Cbhuvi27 — Fri, 15 Nov 2024 20:57:13 GMT

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')

Re: Total in pivot table not working

TauseefKhan — Fri, 31 May 2024 14:15:28 GMT

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.********

Re: Total in pivot table not working

Cbhuvi27 — Fri, 31 May 2024 16:49:38 GMT

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

Re: Total in pivot table not working

eneny — Sat, 01 Jun 2024 08:51:50 GMT

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.