Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following expression which works perfectly when an Order is selected and shows the correct return, however when no selections are made the total is the same on all lines and a sum total of all lines in the total.
Here is the Meaure
Sum(aggr(sum( total Aggr(Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight),Fibres) )
, "Portal Order No." )
)
With no selections made
With a selection made
Can anyone assist so that the when no selections made the lines show their correct returns.
Thank you for your help in advance
Daniel
Sum(Aggr( Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight) , Fibres , "Portal Order No.")))
and change total in chart to sum of rows
Hi @davyqliks ,
As you have aggregated the sum on the order number that results in the getting output.
you can try below expression
Sum(sum(total Aggr(Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight),Fibres)))
Sum(Aggr( Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight) , Fibres , "Portal Order No.")))
and change total in chart to sum of rows
Thank you for the reply,
This still returned the incorrect values:
I have been playing with the expression and found the below worked.
Really Appreciate all of your time and effort, i would not have got to the below without this help!
sum( Aggr(Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight),Fibres, "Portal Order No.") )
Hi,
Thank you so mush, by trial and error i found the same but your help is very much appreciated.
Thank you