Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a chart that contains a Pivot table. I am trying to count the number of transactions by person on a given day. However, I only want to show the occurrences when there are multiple transactions in a given day by the same person. I do not wish to see the single transactions on a given day. So, if a person made more than one transaction on a day, those are the ones I want to display. How can I do this?
Based on you criteria, I created a sample file and attached here. Hope this helps..
Not really sure about your requirements, maybe like this
- Create a pivot table chart
-Two dimensions, Persion and Day / Date
- 1 expression:
=If(Count(DISTINCT TransactionID)>1, Count(DISTINCT TransactionID))
Based on you criteria, I created a sample file and attached here. Hope this helps..