1 2 Previous Next 27 Replies Latest reply on May 21, 2017 4:08 PM by parvinder.bindra.0 Branched to a new discussion.

# Table Calculation Callenge

Hi All,

I am struggling with a table calculation question where the input data is pasted along with the respective output.

1 ) The objective is to find the distinct count of values in the Category and Manufacture columns based on Region and Segment columns.

I am able to perform the calculation on Category and Manufacturer on Separate sheets, but unable to do them while having them in same sheet as two columns.

2) Distinct count of first two columns (Region, Segment) and displaying at the bottom of string columns also seems pretty challenging to me.

Parvinder

Output Expected from input data

 Region Segment Category Manufacturer East Consumer 3 4 Head Office 2 3 North Consumer 1 1 Corporate 1 1 Regional Office 2 1 Branch Office 1 1 South Head Office 3 3 3 5 13 14

Input data to the workbook

 Region Segment Category Manufacturer East Consumer Furniture Adams East Consumer Technology Apple East Consumer Technology ATnT East Consumer Technology Apple East Consumer Office Supplies Belkein East Head Office Technology Canon East Head Office Office Supplies Xerox East Head Office Office Supplies Storex North Consumer Technology Cisco North Corporate Technology Canon North Regional Office Office Supplies Universal North Regional Office Technology Universal North Branch Office Technology Wirebound South Head Office Technology Apple South Head Office Office Supplies Xerox South Head Office Furniture Xerox South Head Office Furniture Adams
• ###### 1. Re: Table Calculation Callenge

Hi there,

Basically you need to create two calculated fileds:

And then drag them to your view:

Hope this helps.

Thanks,

Yemeng

1 of 1 people found this helpful
• ###### 2. Re: Table Calculation Callenge

Yemeng already helped for g.total calc.

If you really need the count under dimension without suing dashboard, it requires quite a bit efforts.

I can put formula here and pleae refer the table format in this link.

Such a simple view, it required 100 steps!! - Having Multiple KPIs - - Still Struggling with Excel ?? <Tableau's Room>

Formula.

Thanks,

Shin

• ###### 4. Re: Table Calculation Callenge

Thank you Shin for suggesting creative way of resolving this issue.

Thank you so much.

• ###### 6. Re: Table Calculation Callenge

Hi Shin,

Can you please provide the steps for the grand total calculation you have done and the steps you followed in formatting the report.

Thank you so much.

Parvinder

• ###### 7. Re: Table Calculation Callenge

Shin,

I am unable to get what you shown as output to the entire thing, please provide me stepwise information.

Thanks,

Parvinder

• ###### 8. Re: Table Calculation Callenge

That's more troublesome task than you think.

It requires at least one hour to prepare the instruction for you.

I don't have time immediately.   may be by tomorrow.

Hope you start from visiting this link and reverse engineering of my attachment.

Such a simple view, it required 100 steps!! - Having Multiple KPIs - - Still Struggling with Excel ?? <Tableau's Room>

Shin

1 of 1 people found this helpful
• ###### 9. Re: Table Calculation Callenge

Shin,

Thank you so much I followed this carefully and I could get the sheet built for me.

• ###### 10. Re: Table Calculation Callenge

Formulas.

Format of the table.

Create place holder as 0

Make axis dual axis

for all eight axis needs to be taken care of

May be I still miss something and you can play around to fix those.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 11. Re: Table Calculation Callenge

Shin,

My second question is can we create a Bar graph using the output we got from the calculation we did for Region and 2 measures, the calculated fields(category and manufacturer).

Thanks,

Parvinder

 Region Category Manufacturer East 3 4 2 3 North 1 1 1 1 2 1 1 1 South 3 3
• ###### 12. Re: Table Calculation Callenge

You mean these view?

Thanks,

Shin

1 of 1 people found this helpful
• ###### 13. Re: Table Calculation Callenge

Hi Shin

I am noticing an issue with GT calculation we did, if we filter the data, it does not do the correct calculation.

Shin,

I filtered the region field into workbook you shared with me, if does wrong grand total calculation.

• ###### 14. Re: Table Calculation Callenge

Hi Shin,

Do we have solution to this issue.

Thanks,

Parvinder

1 2 Previous Next