Manipulate the Total

Question

Hi,I am trying to create a matrix which has a distinct count.My data I'm using for this example is this:AppID.&nbsp;&nbsp; AppStatus.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AppGroup22.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Existing.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; House22.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Existing.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flat 22.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Existing.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flat&nbsp;So, I have 3 records, 1 distict AppID.My Row = AppIDColumn = AppGroupValue = count distinct AppIDThis is what is returned below.AppType.&nbsp;&nbsp; House.&nbsp;&nbsp;&nbsp;&nbsp; Flat.&nbsp;&nbsp; TotalRem.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1Everything is correct based on the logic however, I'd like the Total to show as a 2 instead of a 1.AppType.&nbsp;&nbsp; House.&nbsp;&nbsp;&nbsp;&nbsp; Flat.&nbsp;&nbsp; TotalRem.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2Is there anyway of doing this please, maybe like a grouping perhaps?

daniel29195 · Answer

M_SBS_6&nbsp;&nbsp;use sumx iterator.iterate over the column in the visual,&nbsp;and for the expression, use calculate ( distinctcount( the col you are counting )&nbsp; )&nbsp;&nbsp;let me know if this helps .&nbsp;&nbsp;If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Forum Discussion

Manipulate the Total

1 Reply

Related content

Stored Procedure to Manipulate Tables

Manipulate the total in a matrix

Manipulate Data

Table Totals Manipulation

Table Visual Manipulation