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 IVPlease 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
Community ChampionNever 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.
- Sean
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
- kfschaefer
No, I already have them set to numbers either currency, percent or whole.
Still no totals, in Query Edit mode or Model is there some where I am suppose to set to display Total Row?