Regarding data miss match between bar chart and straight table

[#1]

Hello Friends,

I appreciate your time. I have a bar chart with drill down group dimension(Category,Sub category,Product) and Amount as expression. I cloned the same into a straight table, now the total Amount is same but values are different under different categories as well as under sub categories.When I still drill to products,the bar chart is showing only positive values (but when I click some negative amount in straight table,the bar chart is then showing the negative value) but on a simple scroll of bar chart it is showing only positive value.

I have attached a sample image. Could anyone help me on the same.

Thank you!

Best regards,

Kiruthiga

[krishnacbe]

Hi,

Try to check the Show All Values checkbox for the Dimension in Bar Chart.

[#3]

Hello Krishna,

Thank for your time. Yes its checked

[krishnacbe]

Can you share some sample data so that we check the issue.

[Anonymous]

CAn you attach a sample .qvw, do that we can get cleaner picture of the issue

[#6]

Hello Krishna,

Thanks for your time, I just gave a full accumulation under dimensions.,which caused the issue.Got it now.

Thank you again!

[#7]

Hello Shiva,

I appreciate your time,got it now!

Thank you!