Forum Discussion
Helper VMatrix - total for every row??
Hello All,
My matrix is showing the total for every row! How can I make it shows totals per “station” or per “shift”?
Thanks!
Hi RichFlorida
The same feature should give you the option to turn on/off subtotal for each column/field in the matrix row. After turning on Per row level subtotal and selecting a series, you should be able to see the option in the next tile. Notice that I turn off the subtotal for column YYYYMM in the screenshot below thus the visual is not showing the subtotal for it.
6 Replies
- danextian
Super User
Hi RichFlorida ,
Turning this feature on should give you the option to show the subtotal for each field in the row.
- RichFlorida
My point is that I DO NOT want subtotal for each field in the row.
I want subtotal only for one of the field, "station" for example.
- danextian
Hi RichFlorida
The same feature should give you the option to turn on/off subtotal for each column/field in the matrix row. After turning on Per row level subtotal and selecting a series, you should be able to see the option in the next tile. Notice that I turn off the subtotal for column YYYYMM in the screenshot below thus the visual is not showing the subtotal for it.
Hi danextian I tried to check your response, is there any reason for "Apply settings to row level" not working?? I tried the same for total on my portfolio but it still shows the total on all rows (Attached image is for reference)
- danextian
Hi rdannayak1 ,
You'll need to apply the settings for each field in the row. Per your screenshot, the setting only applies to Portfolio, you'll need to do it for the other fields as well.
danextian Sometime we ignore small things in front of our eyes, You are Awesome, that trick worked, Thanks again Danextian 🙂
