I have a task where i am trying to filter out data based on the 80% of running sum of my sales.
After putting 80% running sum calculation - RunningSum(Sales), i am trying to put the dimension to color shelf, which is spliting each bars into two. The " 80% running sum calculation" is also now getting evaluated on based of that dimension too. I Dont want this to happen.
I am trying to use LOD(Ie exculde ) with runningsum (Sales) but it not working.Please provide you suggestions!!