Pivot table data getting wrongly from table

[djaykumar]

Hi All,

I  am facing issue with pivot table. As I am getting wrong data in pivot table from source table 

please find below screenshot

In the above screenshot dimension value is correct where as calculated value is getting wrongly for some rows.

Please help me in this as I am struck in deep.

Thanks,

Jay

[lironbaram · Accepted solution]

hi 

it's seems you have several rows for the combination of dimension you use 

you can see that where the numbers are "wrong" , you can always divide the expression by the net value dimension 
and you'll get an integer , 

as rule of thumb charts don't get you the wrong numbers , it's related to your source table 

you should either remove duplicate rows, or use another expression 

[djaykumar]

Hi Lironbaram,

Thanks for Reply

As per you I have loaded again from source and I am getting correctly now.

Regards,

Jay