Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am encountering an issue when creating a report.
I have 2 tables - as in the below example
A. sales
YEAR_MONTH / AREA_SALES_MANAGER / PAYER / SALES VALUE
201906 / Daniel X / LIDL / 1000
201906 / Daniel X / ALDI / 1500
.....
B. calendar
YEAR_MONTH / DAYS_PASSED / NUMBER_OF_DAYS
201906 / 24 / 25
My pivot table should show a calculation like the image
The formula for the actual trend is
=[SALES VALUE]/(AVG(DAYS_PASSED))*(Avg(NUMBER_OF_DAYS))
Do you have any ideas?
May be try
Avg(
Aggr(
Sum([SALES VALUE])/(AVG(DAYS_PASSED))*(Avg(NUMBER_OF_DAYS))
,Dim1,Dim2..)
)