Forum

Notifications
Clear all

Frequency count in pivot table

2 Posts
2 Users
0 Reactions
81 Views
(@benr)
Posts: 6
Active Member
Topic starter
 

Hi there

Would appreciate help on a question. I want to count the number of customers who have had at least one transaction in three years of the last five completed financial years. Is there a formula I can use to add to the report shown to yet a 'yes' or 'no' on each line of the report shown?

Many thanks in advance for any suggestions.

Ben

 

excelpic1.PNG

 
Posted : 09/09/2020 8:11 am
(@purfleet)
Posts: 412
Reputable Member
 

can you add an example workbook rather than a screen shot? oitherwise we have to guess the data layout

 
Posted : 09/09/2020 8:16 am
Share: