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

[P_Kale]

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

@marcus_sommer 

@sunny_talwar 

@swuehl 

@Anil_Babu_Samineni 

[marcus_sommer]

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.