6 Replies Latest reply on Oct 3, 2018 9:27 AM by meenu choudhary

How to Change it %

Hello All

Sorry if its a Basic Question  i am beginner in tableau. So i need to make % out of Total like Below 1st one  is 23+29=52, 29/52*100=56%

How can i show this calculation  in Tableau

• 1. Re: How to Change it %

Hello Deepti,

You can try below approach:

Super store Example:

• 2. Re: How to Change it %

Hi Meenu

Thanks for Reply But my Total is in S_Count and Warranty Rep has divided in Different Area

This is Formula

IF [RESOLUTION_CD] = 'Analysis Needed' OR [RESOLUTION_CD] = 'System WR-Free' OR [RESOLUTION_CD] = 'Non Triage Return' OR [RESOLUTION_CD] = 'Brewer Platform Swap' THEN 'Warranty Replacement'

ELSEIF CONTAINS([RESOLUTION_CD],'OOW') THEN 'Out of Warranty'

ELSEIF [RESOLUTION_CD] = 'MBG' THEN 'MBG'

ELSEIF [RESOLUTION_CD] = 'Sent Part' THEN 'Sent Part'

ELSE 'Troubleshoot Successful'

END

• 3. Re: How to Change it %

Hi Deepti,

Use a quick table calculation to obtain % of Total from your measure.

Change the direction of the table calculation from the default table across to table down.

Let me know if this solves your issue.

Cheers,

Sasha

1 of 1 people found this helpful
• 4. Re: How to Change it %

Hi,

You can click on SUM(SR_COUNT) . Go to Quick Table Calculation -> Percent of total .

It will give you the result

It will give you the output.

• 5. Re: How to Change it %

Thanks i can see Changes. Thanks