Wrong Values displayed in the Grid Chart

[manideep78]

Dear Community,

I have an issue with the Grid Chart.

Dimensions:

Country

Year

Product

Expression =Sum(Sales).

As you can see in the below Grid Chart, the plot is splitting according to the values. But When I placing the cursor on any partition it showing 700 instead of corresponding values. When I place cursor on red it should display 5000, green =700, blue=500. But for every partition it is displaying 700.

Can you please help me where I am going wrong.

Thanks & Regards

Manideep

[manideep78]

Yousef,

I wanted to check Sales for each product in the year for each Region (like pie chart.) so that I am using 3 dimensions here. It is appropriate that we can use 3 dimensions in this scenario.

[Yousef_Amarneh]

use the bar chart instead, it's working, please see the attached file

[male_carrasco]

Hi,

attached a example.

Ale

[#5]

Hi,

Try the below expression

=Sum(Total Aggr(Sum(Sales),Year)

[manideep78]

Hi Alejandra Carrasco

In your example, the pie chart shows correct values. But I need to see all those values at a time for all dimensions. So I took Grid Chart. If I Clear selections I could see all  the Country, Product and Year as Dimensions. So I need sum(sales) for all those dimensions.

[manideep78]

No Luck Soumya Jigajinni

[ashfaq_haseeb]

Hi,

May be something like this.

Regards

ASHFAQ

[male_carrasco]

check out this way.

Ale

[manideep78]

I already tried this in the Pie Chart. Can't I get this in the Grid Chart?

[manideep78]

Hi Alejandra,

I could get this with other charts. I am confirming that whether I can get this functionality in the Grid Chart. I think this is a bug in the Grid Chart. Thanks for the effort.