Discussions
Can a Saved Search output as a Pivot Table
I am wondering if you can produce a Pivot Table from a Saved Search.
I have a saved search that results:
City1...Business....$.100.00
City1...Charity.....$..10.00
City2...Business....$.500.00
City2...Foundation..$2000.00
City3...Business....$.300.00
City3...Charity.....$.200.00
City3...Foundation..$.900.00
What I would like to have is:
Cities......Business...Charity...Foundation...CityTotals
City1.......$.100.00...$.10.00................$...110.00
City2.......$.500.00.............$..2000.00...$..2500.00
City3.......$.300.00...$200.00...$...900.00...$..1400.00
CatTotals...$.900.00...$210.00...$..2900.00...$..4010.00
Any ideas? Without using Excel or Reports.