This content has been marked as final. Show 6 replies
I attached a QVW that contains my test data.
I want to crate a straight table that tells me how many employees had X number of sales over a date range (weeks). Example of table below...
Sale Count Employee Count AVG Sale Total
1 21 $35
2 18 $28
3 19 $34
4 15 $25
5+ 10 #16
I have a unique key for each transaction/Sale. I believe I need to create a calculated dimension using that unique sale key.
Any help would greatly be appreciated.
Thanks in advance.