Hi All,
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
Thanks
Randy