Forum Discussion
Helper IVCreate a running total that changes on filtered records
Wow all you numbers must Data Type: Text - all seem to be left justified and that explains lack of totals!
Go to Modeling Tab and Check Data Type: for each Field in your table
Helper IVIs there another way to display the total on the same visualization?, where it is display always at the bottom without scrolling?
Community ChampionIf your table has items only in the Values - then the Total Row is fixed - even if you have scroll bars it will remain visible.
if you also have items in the Rows then you will have to scroll down.
No you can't change the location of the total row!
- kfschaefer
Please explain this? I am new to this?
"If your table has items only in the Values - then the Total Row is fixed - even if you have scroll bars it will remain visible."
My table has numerous values and I thought group on that table would get me the running total, however, this gets me a static value not changable by the slicers.
K
- Sean
Never mind in a table all you have is Values. In a Matrix you can have Rows and Columns along with the Values.
bottomline your total row in a table should always be visible on the bottom row
with or without scroll bars it stays fixed and always visible
make sure it's turned on in the options - but it comes on by default anyway
as fas as the running total did you try my DAX formula
- kfschaefer
sorry, I turned on the totals for the visualization and not totals are displayed.
Still unsure how to get the running totals to display on the visualization without using a separate visualizaton.