Average in pivot table

[anuradhaa]

I have sales data based on salesman and city.

I need to display it in pivot table and get averages

City	A	B
Salesman
AA	avg	avg
BB	avg	avg
	Avg of City A	Avg of City B

and i'm using previous days data

i use below expression, but figures are wrong

=ceil(Avg({$<date={"=date>=Date(ReloadTime()-1,'DD-MM-YYYY')"},type={"I"}>}

((sales)), 0.01)

Thanks

[MK_QSL]

Sample data or sample application please !

[anuradhaa]

see attached

[Kushal_Chawda · Accepted solution]

try

=ceil(Avg({$<date={"$(=date(ReloadTime()-1,'DD-MM-YYYY'))"},type={"I"}>}

sales), 0.01)

or

=ceil(Avg({$<date={"$(=date(ReloadTime()-1,'DD-MM-YYYY'))"},type={"I"}>}

total <City> sales), 0.01)

[nagarjuna_kotha]

PFA

[jonathandienst]

The sample SOURCE data is totally unhelpful. Your query is about a QV sheet object. You need to upload the qvw model or a sample containing the object and displaying the problem.

I suspect that it is to do with the fact that a pivot table does not sum the rows, it applies the expression to the total data set - and this value may not be the same as the sum of rows. If you post a useful sample qvw doc you will get more specific and useful help.