Skip to Content
0
Jun 05, 2009 at 12:00 PM

No Sum on a certain numeric column

27 Views

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 😉