10 Replies Latest reply on Aug 25, 2018 12:08 PM by Shinichiro Murakami

# Need Total in Chart

Hi ,

I am stuck for a solution wherein Stacked Bar chart can show total in separate bar for all of those quarters. it will be good if i ll get calculation for this.

Reference print is given below:

i have attached sample .twbx file too.

Thanks for help.

Regards

• ###### 1. Re: Need Total in Chart

Hi Vamsi,

Have you tried selecting "grand total"

• ###### 2. Re: Need Total in Chart

Hi Meenu,

I need total of all Q1, Q2, Q3, and Q4 by putting calculated field.

Thanks for looking into this.

Regards

• ###### 3. Re: Need Total in Chart

Hi Meenu,

Suppose i have 3 geography

A- Americas

B- EMEA

C- APAC

I have Sales in percentage for Q1FY19 and Q2FY19 in each Geography.

Now i want to calculate Global Sales with these Quarters.

So there Should be Q1FY19 Global Sales Column which shows Grand total of Q1 Sales

and Q2FY19 Global Sales which shows Global total of Q2 Sales.

Hope i am clear here.

Regards

• ###### 4. Re: Need Total in Chart

Hi

Suppose i have 3 geography

A- Americas

B- EMEA

C- APAC

I have Sales in percentage for Q1FY19 and Q2FY19 in each Geography.

Now i want to calculate Global Sales with these Quarters.

So there Should be Q1FY19 Global Sales Column which shows Grand total of Q1 Sales

and Q2FY19 Global Sales which shows Global total of Q2 Sales.

Hope i am clear here.

Regards

• ###### 5. Re: Need Total in Chart

HI Vamsi

I am not quite sure but you mean add label of g.toal for ea quarter like this?

Thanks,

Shin

• ###### 6. Re: Need Total in Chart

Here It is:

Thanks

Deepak

• ###### 7. Re: Need Total in Chart

Hi Shin,

Please have a look in the below given print screen scenario.

So data is in percentage for each geography with Q1 and Q2. I need total for each Q1 and Q2 (i mentioned Total), and For All Q1FY19 I need grand total and For all Q2FY19 I need grand total seperately.

Hope you understand my problem.

Regards

• ###### 8. Re: Need Total in Chart

Here it is.

• ###### 9. Re: Need Total in Chart

HI Vamsi

This format Viz requires data-re-shaping.

Thanks,

Shin

• ###### 10. Re: Need Total in Chart

One more thing.

More Tableau-like approach is set this type of hierarchy.

Thanks,

Shin