Filter Z:row node

Feb 3, 2014 at 7:29 PM
Edited Feb 3, 2014 at 7:30 PM
Hello Everyone,

I have a sales list with salemonthyear and category as columns. I need to calculate count for last 12 month's sales by month name by category. I wrote a CAML query to get the last 1 year data from the list. In Javascript i'm able to calculate the last 12 month names along with year for filter purpose . Since there are lot of calculation involved, I don't want loop the trough all the items in each funtion and filter using If condition.

Is there any way I can filter directly Z:row with monthname and category.

Please help me
Coordinator
Feb 3, 2014 at 7:31 PM
It's a little tough to know what to tell you without understanding your data.

M.
Feb 3, 2014 at 8:15 PM
Marc, thanks for the response. Here is the sample data and output. Hope this helps you in understanding the requirement.

Sale No MonthYear Category
1 Feb-14 Iphone
2 Feb-13 iPad
3 Jan-14 Iphone
4 Jan-14 Iphone
5 Jan-14 Iphone
6 Jan-14 iPod
7 Dec-13 ipad
8 Dec-13 iPad
9 Dec-13 Mac
10 Nov-13 Mac
11 Oct-13 Mac
12 Oct-13 Iphone


output
  __Iphone  ____iPad    ____Mac ____iPod__
Feb-14 1 1
Jan-14 3 1
Dec-13 2 1
Nov-13 1
Oct-13 1 1
Coordinator
Feb 4, 2014 at 2:35 PM
I'd just push the values into an array and accumulate them. It doesn't seem like much data.

M.