I want to ask about how to convert table calculation info formula in calculated field.
In this case I'm using Superstore database
So i want to get the percent of total from Sub-Category, with table calculation I simply Go to Quick Table Calculation --> Percent of Total, and Compute Using --> Sub-Category.
But I need to convert it into calculated field as basis for anoother calculation. When I go to the measure box, the formula is like :
COUNTD([Customer Name]) / TOTAL(COUNTD([Customer Name]))
This formula is simply compute percent of total using Table(Across), how can i convert the calculation but using Sub Catergory as the base
Follow below steps
Click on Default Table Calculation Option
select compute using as sub-category
Click Ok button
The calculated field summarizes values using sub-category
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...