Calculate total on rank

[sogloqlik]

Hi.

I have the following demand: I have the sales and discounts of 5 customers for 2017 & 2018.

I have to rank the top 3 with their data for 2018 and 2017.

So far so good.

Now, I have to calculate the sales of 2018 with the discounts percentage of 2017 and compare it to the discount percentage of 2018. How can I achieve that?

Attached is an excel file: A DB sheet and the required result in the second sheet. I need to calculate cells H8 and H9 (And to show it in a KIP of another way)

Thanks 

Motty

[jyothish8807]

Hi,

Are you looking for an expression like this ?

(num(sum({<year={'2017'}>}Discount)/sum({<year={'2017'}>}sales),'##.0%'))*
sum({<year={'2018'}>}sales)

or you want to replicate the pivot chart in the same format ?

[sogloqlik]

Both