I want the text "Total Quantity" [Channel Quantity] along with the channels to be shown with the text "Channel Count" [Count Channels] in the following format.
Example:-
Flipkart Total Quantity 84 Channel Count 67
Amazon Total Quantity 54 Channel Count 32
โ
The "Total quantity" is possible to show if you have another column where that text is added. The "Channel count" is not possible because you can aggregate only with one value.
If you have another column where that text is added (+ with the original value) and then group by that.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |