Hi,
I have a data feed as follows:
.png)
I want to show the % of relevant names from each domain, and i want to be able to filter it by domain.
for example: in domain A 25% of the names are relevant.
How can i do this?
Thanks,
Yaara
3 Replies
Hi,
A pivot table is a nice idea, but i want my mashup to work using simple reports which will run automatically once a day without any intervention (like inserting a pivot table into them).
thanks
Hi Yaara,
of course MashZone can help you, you don't need to go the Excel Pivot way. What you basically need is counting data rows after filtering according to your "is relevant?" column. Most has been asked (and answered) by Roy before. If you need further help, just drop message.
Regards
Stephan
Jim Thompson on
Have you looked at using a Pivot Table in Excel?