Hi,</SPAN>
I’m trying to do some banding in Powerpivot.</SPAN>
I need to be able to band the ‘Days Open’ results – there’s one catch – there are duplicate ‘Order No.’s’ which will always have the same ‘Days Open’ number. I only want one record per dupe to be included within the bandings.</SPAN>
My ‘Date’ column is linked to a calendar.</SPAN>
I would like to be able to slice on the Include field ‘Y’ and slice on any particular dates within the calendar.</SPAN></SPAN>
<TBODY>
</TBODY><COLGROUP><COL span=5><COL><COL></COLGROUP>
Thanks
I’m trying to do some banding in Powerpivot.</SPAN>
I need to be able to band the ‘Days Open’ results – there’s one catch – there are duplicate ‘Order No.’s’ which will always have the same ‘Days Open’ number. I only want one record per dupe to be included within the bandings.</SPAN>
My ‘Date’ column is linked to a calendar.</SPAN>
I would like to be able to slice on the Include field ‘Y’ and slice on any particular dates within the calendar.</SPAN></SPAN>
DATA SET</SPAN> | DESIRED RESULT</SPAN> | |||||
Date</SPAN> | Order No.</SPAN> | Days Open</SPAN> | Include</SPAN> | Band Name</SPAN> | No.</SPAN> | |
01/08/2013</SPAN> | 1</SPAN> | 4</SPAN> | Y</SPAN> | 0-5</SPAN> | 2</SPAN> | |
01/08/2013</SPAN> | 2</SPAN> | 25</SPAN> | Y</SPAN> | 6-10</SPAN> | 0</SPAN> | |
01/08/2013</SPAN> | 3</SPAN> | 38</SPAN> | N</SPAN> | 11-15</SPAN> | 0</SPAN> | |
01/08/2013</SPAN> | 1</SPAN> | 4</SPAN> | Y</SPAN> | 16-20</SPAN> | 1</SPAN> | |
02/08/2013</SPAN> | 4</SPAN> | 18</SPAN> | Y</SPAN> | 21-25</SPAN> | 1</SPAN> | |
02/08/2013</SPAN> | 5</SPAN> | 62</SPAN> | Y</SPAN> | 26-30</SPAN> | 0</SPAN> | |
02/08/2013</SPAN> | 6</SPAN> | 2</SPAN> | Y</SPAN> | 31-35</SPAN> | 0</SPAN> | |
01/08/2013</SPAN> | 2</SPAN> | 25</SPAN> | Y</SPAN> | 36-40</SPAN> | 0</SPAN> | |
41-45</SPAN> | 0</SPAN> | |||||
46-50</SPAN> | 0</SPAN> | |||||
50+</SPAN> | 1</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=5><COL><COL></COLGROUP>
Thanks