Cake chart: % of increasing, decreasing customers

[#1]

Hello,

I would like to create a cake chart representing % of increasing , % of decreasing and % of flat customers.

Increasing: number of customers that are growing current year units sold vs prior year units sold: criteria is >10% growth

Decreasing: number of customers that are decreasing current year units sold vs prior year units sold: criteria is <-10% growth

Flat: number of customers that report flat trend for current year units sold vs prior year units sold: criteria is between +10% and -10% growth

Furthermore, I want the possibility to  sort by period/months (e.g. select Jan, feb, or select Jan, Feb, Mar,...)

Find attached the database source.

could you please help me in figure out how to do it?

thank you

Jessica

[RonaldDoes]

Hi Jessica,

Great question, easily solved through the magic of set analysis.

The below example shows how to count just the (unique) accounts with a sales increase of over 10%, compared to the previous year.

Count(

{<Account =

{"=(sum({<Year = {'$(=Max(Year))'}>}[Net Sales])-sum({<Year = {'$(=Max(Year)-1)'}>}[Net Sales]))/sum({<Year = {'$(=Max(Year)-1)'}>}[Net Sales]) > 0.1"}

>} DISTINCT Account)

I've atttached an app with your data and the chart you're trying to create.

Kind regards,

Ronald