Hello Friends!
Please check below scenario.
Please check table TABLE1 in attached Excel
I’m providing X,Y values from filter pane, and able to find sum of actuals for X,Y company (table 1)
But ADJ value needs to be arrived based on COMPANY_GROUP & KNOCK-OFF COMPANY GROUP (KNOCK-OFF COMPANY GROUP, which is same as COMPANY_GROUP values like ‘X’,’Y’,’Z’,’K’)
When selecting MULTIPLE COMPANY_GROUPs from FILTER PANE,
From those above tables, trying to arrive TOTAL (RESULT tab),
But while arrive ADJ value, need to check whether KNOCK-OFF COMPANY GROUP (Y,V,W)is fallen under
COMPANY_GROUP combination selected {Here COMPANY_GROUP as of now it’s (X,Y,Z)}.
For this, Variable I declared from Filter pane input as
Vconcat = CONCAT(DISTINCT COMPANY_GROUP,’,’)
But need to compare the Vconcat everytime with Knock off company group like below
SUM(If(SubStringCount(Vconcat,[ KNOCK-OFF COMPANY GROUP] )>=1, ADJ,0)).
Using pivot for this.
Is not working. Any suggestion highly appreciated.
