Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a table below
SaleID, Amount
1,500
2,300
3,5000
4,3000
5,1000
I want it displayed like this
Key,Value
Sales ,5
Total Sales,10000
Average Sale, 2000
I am struggling putting the key value in the table. I have researched pivot tables but I don't think this would be resolved with that.
Thanks,
You could do it with a straight table using no dimensions and three measures with no total aggregations. See picture below. I'll also attach a qvw file for reference.