Average in text box

[#1]

Hi.

I have a pivot table contains of two demintions dates and departments and the expression is  Sum() sales for everyday.

I am trying to get the average for sales per day in a text box and it is not giving me the correct data.

[#2]

so the expression is Sum(Sales)..

I tried to add in the text box Avg(Sum(Sales)), it didnt work.

Any ideas

[its_anandrjs]

Hi,

You have to use If(dates = today(),Avg(Sales) ) it will calculate average on taly basis paste this code in any text box and let me know.

or

you can use only this =Avg(Sales) with equal sign in text box.

Rgds

Anand

[SunilChauhan]

avg(Sales)

or

avg(aggr(sum(Sales),dates))

[danieloberbilli]

what if you just write: avg(sales)

or try

avg(aggr(sum(sales),dimension Y))

Regards

Daniel

[its_anandrjs]

Hi,

See the attached sample file

Rgds

[danieloberbilli]

Everything is right. But I guess you need to add the sales per day as data in your model. This data is missing.

Until now you only can calculate avg(sales)/365  -> but I guess that is not what you need

[#8]

The attached file is not working because it was created by another person.

If I use avg(aggr(sum(sales),dimension Y))   I get data but the data is not correct as if I do the math myself i get different Nrs.

[SunilChauhan]

avg(aggr(sum(sales),dimensioncolumn1,dimenssion column2,.......))

try using this

where dimensioncolumn1 is dimension Y

[its_anandrjs · Accepted solution]

Hi,

Use

=Avg(Sales)

Or

=Avg( Aggr ( Avg ( Sales ),Dimension X ) )

Or if dimension is more use

=Avg( Aggr ( Avg ( Sales ),Dimension X, Dimension Y,Dimension Z ..... ) )

Rgds

Anand