Incorrect values in pivot table

[udaya_kumar]

Hi,

I have created a pivot table with two dimensions and an expression.

Two dimensions,

Segment and Day

Expression

Avg(value)

And given show value in % in number format of the table.

The value comes fine for each Segment (A, B, C, D,...) and Day wise (Mon, Tues, Wed, Thur, Fri, Sat, Sun)

for example.

Segment	Sun	Mon	Tue	Wed	Thu	Fri	Sat
A	15%	15%	15%	15%	10%	15%	15%
B	15%	15%	15%	15%	10%	15%	15%
C	-	-	-	-	-	-	-
D	-	-	-	-	-	-	-

If you consider the above table which looks like pivot table, Consider these values, and if you sum the % value by segment and day wise.

A - 7 days - 100%

B - 7 days - 100%

I get these types of right values in straight table, but in pivot table it gives values like

For segment A

Sun - 13%

Mon - 13%

Tue - 13%

Wed - 13%

Thu - 8%

Fri - 13%

Sat - 13%

Why is that pivot table shows incorrect values, but other charts like straight table, bar chart gives right value when I am using Avg expression?

[sunny_talwar]

What are the expressions you are using?

[udaya_kumar]

Just one expression, Avg(Value)

[sunny_talwar]

What about in the straight table? Same expression?

[Anonymous]

Hi Uday, could you share your data or one sample of your app?

Regards!

[udaya_kumar]

Yes, in the straight table also the same expression.

It works fine there, but not in pivot table.

Data is from client, so cannot share it

[Anonymous]

Try with this two expressions:

Avg(TOTAL <Segment, Day> Value) or Avg(Aggr(Avg(Value),Segment,Day))

Regards!!

[udaya_kumar]

I had tried this expression before Avg(Aggr(Avg(Value),Segment,Day)), it did not work and i tried your given expression Avg(TOTAL <Segment, Day> Value) , this also did not work.

[Anonymous]

It is complicated if we can't see some data example, you can do an Excel file with dummy data to help you.