Can you explain why you do not want to use Table Calculations? I guess if you're looking to pass calculations back to the data source this could make sense, but they are extremely powerful for customer analysis once a viz is created with the proper dimensions on Rows/Columns/The Marks card.
If I could understand a bit more about what you're hoping for that would help me to help you -- any chance of a mockup of expected results?
Thanks for your reply.
I want to use this on my company dataset and since it is sensitive data, I am trying to do it first in default data source.
Identify the Top 5 customers where cumulative % of Total > lets say 60% in this case and I want this to be dynamic.
If you have any ideas better Visualizing this data set, let me know.
Tableau Forum.twbx 1.1 MB