Although Tableau very much resembles Excel's pivot tables, it is much different than excel in that Tableau is not cell-based, i.e. your formulas should be referencing fields or viz partitions instead of cells. Having said that, if your fields in Tableau match the column headings from above, the formulas (called in Tableau "calculated fields") should be like this:
SUM([QTY Rejected]) / SUM([TOTAL QTY]) for your [% CANCELLED] field, and
SUM([QTY CMp]) / SUM([TOTAL QTY]) for your [%COMPLETED] field.
This assumes your data comes at the granularity presented above. Feel free to post a mockup workbook and/or some sample data if you need further help on this, so that I can have a look.
Thanks for your response .
actually it was my mistake in posting the question, QTY CMP and QTY REJECT are part of the main table QTY RESULT , so when I bring "QTY RESULT" in column shelf it created two columns QTY CANCEL and QTY COMPL and total quantity is by going to analsysis and checking total column .
So where I am confused is how do I say that Cancel/grand total =% cancel because cancel is not a independent field it is the outcome from column "QTY RESULT: what I pasted is excel.and total qty wa calculated using b2+c2
can u please guide me how to fix this ?
Have a look at this workbook that is a mockup of your situation based off superstore data. I tried to propose a solution based on my understanding of your data structure. If I guessed correctly, then you can do with simple aggregate measures as shown in the second sheet. However your data structure might be different, and you may need to resort to table calculations then. Feel free to post a packaged workbook and/or some sample data, so that I can hep you further with this.
You can also have a look at this workbook, which treats quality inspections for discrete manufacturing process, where the outcome is either pass, or rework, or scrap. It applies basically the same technique - counting the records of each type for a certain period of time, and presenting aggregate statistics by various dimensions.
Hope this helps,
Hi mehul parekh
create a calculated field
cancelled % = SUM([QTY Rejected]) / SUM([TOTAL QTY])
Completed %=SUM([QTY CMp]) / SUM([TOTAL QTY])
then after successful creation of calculated fields.
1.right click on "cancelled %" field
2.click on default properties
3.choose number format
4.then select percentage , Click ok
repeat this for your other field Completed %
Thanks & Regards