I have a column in which I have four attributes. I want to be able to calculate a % on the total of those four regardless of which value I look at. If I look at all 4 and calculate a % of total I get the answer. However, if I want to now slice and dice based on just one of those values or provide a map view on just one of those values, I lose the correct % because I lose the total.
An example would be that I have four states, NJ, NY, CT and FL and each one of those have total. I want to view just Florida, but I need the calculation to remain the same against the total - FLorida is a % of the total. Is there a way to do a calculation against maybe the number of rows?
Do you still need help with this? If so, are you able to post a packaged workbook (twbx file)? You might be able to do this by right click and hide the unwanted states.