facing issue while creating dropdown

Hi Kiranmayi,
Try adding “OVER (PARTITION BY "PO_LINE_ITEM"."VENDOR")”
it will ensure that the Running_total is calculated per vendor rather than globally.

Hi Team,

could you help me out for the PQL query ?

CASE 
    WHEN 
        RUNNING_TOTAL(SUM("PO_LINE_ITEM"."NET_VALUE_LINE_ITEM_IN_REPORTING_CURRENCY")) 
        OVER (PARTITION BY "PO_LINE_ITEM"."VENDOR") 
        /
        GLOBAL(SUM("PO_LINE_ITEM"."NET_VALUE_LINE_ITEM_IN_REPORTING_CURRENCY")) <= 0.8 
    THEN 'Top 20% Vendors' 
    ELSE 'Remaining Vendors' 
END
 

Hi Team,

I have used above pql query which was given by you. But it is showing as attached. Running total is not working in button dropdown.

Hi Team,

Please help me on above mentioned

Thanks,

Kiranmayi