- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
aggr function
I am struggling with the attached...
I am trying to show how many customers sales have grown / how many have decreased (same counts as decreased)...
I am on QV 8.2 so please bear this in mind with any response...
Thanks in advance for any assistance provided...
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe this is more clear...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anyone any suggestions on this?
Even if it is to say it cannot be done....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Paul,
excuse me but I speek only a little english.
I'm looking for the best response for you, by now I found only an "half" response.
I fear that you cannot calculate in this chart the number of customers with growthing sales count, or decreasing one.
You need another dimension, resulting of the customers' aggregation for sales growth or decrease.
You can view total sales for year in the "total" column of a pivot table.
Look at my doc!
I hope it is useful.
Bye
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe this is more clear...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Roberta this worked great....