Forum Discussion
Advocate IISumming a column in table visual
I'm sure this has been asked a bunch of times: How do I get the total to show up for the Amount value? If I use the "Sum" aggregation it give me too large of a number.
I have searched the forum, but I can't figure out how to phrase my question in a way that the search results give me a good result. It's almost like it's too basic a question! Every search I do gives me answers on doing much more complicated things.
2 Replies
Nothing can be said about it because you have not shown us the model and how the measure is written.
- jvaught
"Amount" is raw data. "Sum of Amount" is just selecting "Sum" in the aggregation choices for that column.
I don't know what else to provide, the model has a whole bunch of things unrelated to my question and I've yet to figure out how to provide info without giving away all of my client's data!
Let's try this: I added an index upstream to give me a column I can show you which will also force the table to display not aggregated.
You can see that there are multiple rows with similar amounts (e.g., two rows with Amount = $15k). So without the index the table collapses to what I showed in the OP.
It makes sense to me that "Sum of Amount" will show $30k because there are two rows in the source data with the amount of $15k. My question is how can I get a column total on the "Amount" column which sums the row values shown, namely only one occurrence of the $15k value, one occurrence of the $17k value, etc. Like this:
I am doing my best to provide the info needed, but I don't really know what to provide. If there is still not enough here for you to move the ball down the field with me, maybe you can ask a clarifying question or two. Thanks in advance.
