topic Calculate total on rank in App Development

Calculate total on rank

sogloqlik — Tue, 11 Dec 2018 06:40:58 GMT

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

Re: Calculate total on rank

jyothish8807 — Tue, 11 Dec 2018 07:31:03 GMT

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 ?

Re: Calculate total on rank

sogloqlik — Wed, 12 Dec 2018 09:36:47 GMT

Both