▲ 2 r/tableau
Top Accounts
*Due to company policy, I cannot post a screenshot of my tableau*
I want to create one data view in tableau which ranks the account based on the type and cost
Logic: (Like how this pivot in excel works)
- Type Acquistion and Upgrade normally shows positive values. If selected, sum everything then sort desc
- Type Contract end and Downgrade normally shows negative values. If selected, sum everything then sort asc
- If all or any positive-negative type combiniation (for example: the selected types are upgrade, contract end and downgrade), sum everything first then sort desc
u/Legitimate_Show2852 — 3 days ago