Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
cheid_4838's avatar
cheid_4838
Icon for Helper IV rankHelper IV
2 years ago

Due to how the data is structured I had to create columns to break out count versus the dollar amounts associated with each itemcode in the dataset  Each itemcode has a column for quantity and charge.  All I had to do was drag each column into the values field in the matrix to get everything to total up.  Do the totals calcualted or averages matter if the totals come from a measure versus a column?

 

 

 

cheid_4838's avatar
cheid_4838
Icon for Helper IV rankHelper IV
2 years ago

I guess I am trying to determine how this applies to me if the column totals are accurate since they are coming from column totals not measures.  I under how the averages will not be correct if calculating a measure, but shouldn't the averages be accurate since the totals come from columns and not measures?  Thanks for your help.