Value doesn't match

[prma7799]

Hi All,

I have one bar chart and pivot table in that i have used same dimension and expression but why value has changed.

PFA for the same

Thanks

Prashant

[robert_mika]

I'm working on personal edtion so can not open the file but if you can post your data,espression & dimension I can have a look

[sunny_talwar]

What is the expression you are using to calculate Total TP/Unit in your pivot table? If it is any other then Sum, then you will need to use an aggregate function like this:

=Sum(Aggr(yourExpression, [Pack Year], [Supplier Name]))

Note: The above expression is assuming that you only have Pack Year and Supplier name as your dimension in the pivot table.

HTH

Best,

S

[#4]

Hi,

In your expression tab of pivot table, Click on Sum of rows in Total Mode.

Regards

Nandkishor S. Pandirkar

[prma7799]

Hi All,

I don't want to change any expression in Bar chart I want same output as like Pivot Table.

Thanks
Prashant

[robert_mika]

Post your data/dimension/expression....

[prma7799]

Unable to send the data

PFA for dimension/expression

[robert_mika]

prashantbi wrote:

Unable to send the data

You can not attached or are the confidential?

If is the first case :

Go t:

An and then:

[prma7799]

Hi .

PFA for Pivot table description.

Thanks

Prashant

[jagan]

Hi,

Pivot table total will be based on the expression, so it is difficult to show that in Bar Chart and also it is not a correct value, if you sum the value in pivot table the total is not correct.

To fix the Total in Pivot table you can use you should use aggr()

Sum(Aggr(yourExpression, [Pack Year], [Supplier Name]))

Hope this helps you.

Regards,

Jagan.