Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago
Solved

Create a running total that changes on filtered records

I am still pretty new to this and I need to create a process for a running totals on multipe data fields.  I tried using Group by but that does not change when the filter changes the data.  What do I...
General Comment
  • Sean's avatar
    Sean
    10 years ago

    kfschaefer

    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's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago

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's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

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