Hi
I have the following problem. I need a column to calculate based on the other columns value.
So for example if Sales less than 150 it must be 2% else be 10%
I have used calculated key figure and works on the detail.
When I show the detail it does the below, the below is correct.
Customer.......Doc No.............Sales...........Perc
A...................90000................100..............2%
A...................90001.................50...............2%
But if i then remove the doc no. It adds the percenatges. Does as shown below. Do not want this.
Customer.................Sales............Perc
A.............................160................4%
I want it to be as shown below.
Customer..................Sales...........Perc
A..............................160...............10%
Can I do this? Is there a way?
Thanks in advance 😉