Forum Discussion
Helper IVValues in rows, single dimension as column accompanied by total
Hi,
I'm trying to accomplish something that seems tricky. I have calculated values: Average (age), Average (balance), Net worth.
I have those values for 5 different states (NY, KY, CA, FL, TX) , and a filter for states.
Once I've filter for a state, I'd like to show a table with Age, balance and net worth as rows, a column for the states value, and a column combining all the states.
Is that feasable?
5 Replies
- TomMartens
Super User
Hey Sibrulotte ,
I'm not sure if I understand what for you are looking for.
I'm using a matrix visual, the next screenshot shows the initial visualization:
The Values bucket in the formatting pane of the matrix visual provides an option called Show on rows
Turning this option to on changes the layout of the matrix visual to this:
All the fields from the Values well are transposed, from columns to rows.
Hopefully, this is what you are looking for.
If not, consider creating a screenshot that shows how the visual looks like, and use Excel to create the layout you want, and paste this layout as a 2nd screenshot.
Regards,
Tom
- Sibrulotte
Name State Age Balance Net worth Steve NY 40 100 5000 Rick NY 50 300 15000 Samantha KY 50 400 10000 Qourtney KY 60 600 20000 Kyle CA 20 50 100 Paul CA 30 150 300 Shequanisha FL 40 500 20000 Danika FL 50 1500 40000 Bossman TX 50 1200 6000 Greg TX 40 600 1000 And the result:
Florida National average Age 45 43 Balance 1000 540 Net worth 30000 11740 - Ashish_Mathur
- Sibrulotte
Ahish, thank you very much, was not aware of the IsInSCOpe function.
I might have a complementeray question that surfaced from using this:
If one of my measures was a calculate, that had a filter at the end, how do I combien the ALL and the FILTER in the same calculate?
- Ashish_Mathur
You are welcome. It really depends upon the case. Start a new thread with your question - explain the question, share some data and show the expected result.
