Like for like sales calculation wrong and incomplete

[fabioannovazzi]

The app does not filter total sales for like for like.

To show like to like sales by customer it divides total sales (not like for like sales) by the number of like for like customers

see calculation

Should also so total like for like sales

[fabioannovazzi]

In Multitier Barr Chart, 71 like for like customers over 2 years

And 94 and 152 total

Average sales by customer correct

Average sales like for like are wrong because average clustomr sales x number of like for like => total sales

See calculation below

[fabioannovazzi]

works

check here

[fabioannovazzi]

Also correct with multitier

total like for like sales

per client like for like

check