topic Re: Pivote table should display names having values present in all the columns in App Development

Pivote table should display names having values present in all the columns

P_Kale — Tue, 09 Jan 2024 12:05:27 GMT

Hi,

As per attached excel sheet I have generated pivote table in front end.

My ask is I want only to display SP names where values available in all the columns. For e.g. at front end pivote only contains SP names C , F & G only.

Can you pl help to resolve the issue.

Thanks in advance

Re: Pivote table should display names having values present in all the columns

marcus_sommer — Tue, 09 Jan 2024 12:20:14 GMT

You need to apply an appropriate condition - maybe something like this:

if(count(distinct Month) = count(distinct TOTAL Month), sum(Value))

respectively comparing the number of available months per SP_Name against the number globally by ignoring the dimensionality.