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 IVsorry, 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.
Community ChampionWow 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?
- kfschaefer
OK thanks for your time When I recreated the visual with the updated data the Totals now appear. Thanks for putting up with me.
- Sean
Remember this => left justified stuff in a table is NOT numbers
Numbers are always right justified in a table!
Its a helpful and easy way to see!
I bet now they are all on the other side - to the right!