How to create a Chart with a Pivot Table

[cliff_clayman]

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?

[swuehl]

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))

[trdandamudi · Accepted solution]

Based on you criteria, I created a sample file and attached here. Hope this helps..