Select distinct on multiple columns and then sum

Question

Hi ,&nbsp;I have a requirement where i need to find the distinct on column A and B for&nbsp; the related column c and then count.&nbsp;&nbsp;For eg :Input :C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B123&nbsp; &nbsp; &nbsp;abcd&nbsp; &nbsp;2&nbsp;123&nbsp; &nbsp; &nbsp;abcd&nbsp; &nbsp;3123&nbsp; &nbsp; &nbsp;abcd&nbsp; &nbsp;2234&nbsp; &nbsp; &nbsp;xede&nbsp; &nbsp;1Expected Report:&nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B123&nbsp; &nbsp; &nbsp;abcd&nbsp; &nbsp;5234&nbsp; &nbsp; &nbsp;xede&nbsp; &nbsp;1

evanmartinez · Answer

Hi Mohamed,Have you tried building this out using a summary report yet? Summary reports do allow you to pick how your data is grouped and could be built to show you a summary of data based on that grouping. For example:Store&nbsp; &nbsp; &nbsp; &nbsp;Rep&nbsp; &nbsp; &nbsp; &nbsp;# of SalesStore 1&nbsp; &nbsp; Rep 1&nbsp; &nbsp; 2Store 1&nbsp; &nbsp; Rep 1&nbsp; &nbsp; 3Store 2&nbsp; &nbsp; Rep 1&nbsp; &nbsp; 2Store 1&nbsp; &nbsp; Rep 2&nbsp; &nbsp; 1Could be come:Store&nbsp; &nbsp; &nbsp; &nbsp; Rep&nbsp; &nbsp; &nbsp; # of SalesStore 1&nbsp; &nbsp;Rep 1&nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rep 2&nbsp; &nbsp; &nbsp;1Store 2&nbsp; &nbsp;Rep 1&nbsp; &nbsp; &nbsp; 2You would just want to set the summary report to work off of the fields you want to report against. I hope that suggestion is helpful.&nbsp;

Forum Discussion

Select distinct on multiple columns and then sum

Related Content

Distinct Dates

Using Grid Edit to Edit Multiple Records at Once

Default column widths on embedded reports obscuring data

Rearrange Fields/Columns in table

Edit Multiple Records at Once with Grid Edit