Help required for Analysing large data in a pivot table

[Scrumpywill]

hello could anyone help with this please

i have a large customer list and I want to analyse which customers are down on spend month by month year I’ve year and show on a graph

i can do all of the above but the graph is too busy and it’s hard to see the results- out of the list I only want to see the customers that are down this year compared to last year

thank for your help

cheers steve

 

[oldbrewer]

[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]month[/TD]
[TD="width: 64"]cust1[/TD]
[TD="width: 64"]cust2[/TD]
[TD="width: 64"]cust3[/TD]
[TD="width: 64"]cust4[/TD]
[TD="width: 64"]cust5[/TD]
[TD="width: 64"]cust6[/TD]
[TD="width: 64"]cust7[/TD]
[TD="width: 64"]cust8[/TD]
[TD="width: 64"]cust9[/TD]
[TD="width: 64"]cust10[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]month1[/TD]
[TD="align: right"]1179[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]4231[/TD]
[TD="align: right"]923[/TD]
[TD="align: right"]151[/TD]
[TD="align: right"]2872[/TD]
[TD="align: right"]3259[/TD]
[TD="align: right"]2649[/TD]
[TD="align: right"]884[/TD]
[TD="align: right"]2440[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month2[/TD]
[TD="align: right"]4594[/TD]
[TD="align: right"]1213[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]2157[/TD]
[TD="align: right"]2789[/TD]
[TD="align: right"]2655[/TD]
[TD="align: right"]2696[/TD]
[TD="align: right"]1807[/TD]
[TD="align: right"]1818[/TD]
[TD="align: right"]4434[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month3[/TD]
[TD="align: right"]1163[/TD]
[TD="align: right"]601[/TD]
[TD="align: right"]3695[/TD]
[TD="align: right"]3392[/TD]
[TD="align: right"]1274[/TD]
[TD="align: right"]2301[/TD]
[TD="align: right"]1706[/TD]
[TD="align: right"]196[/TD]
[TD="align: right"]2711[/TD]
[TD="align: right"]1569[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month4[/TD]
[TD="align: right"]2151[/TD]
[TD="align: right"]3666[/TD]
[TD="align: right"]3131[/TD]
[TD="align: right"]2111[/TD]
[TD="align: right"]3691[/TD]
[TD="align: right"]4084[/TD]
[TD="align: right"]2971[/TD]
[TD="align: right"]856[/TD]
[TD="align: right"]4711[/TD]
[TD="align: right"]241[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month5[/TD]
[TD="align: right"]4292[/TD]
[TD="align: right"]4395[/TD]
[TD="align: right"]4772[/TD]
[TD="align: right"]3323[/TD]
[TD="align: right"]2214[/TD]
[TD="align: right"]3409[/TD]
[TD="align: right"]1952[/TD]
[TD="align: right"]3410[/TD]
[TD="align: right"]4796[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month6[/TD]
[TD="align: right"]2390[/TD]
[TD="align: right"]3969[/TD]
[TD="align: right"]4033[/TD]
[TD="align: right"]3327[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]1539[/TD]
[TD="align: right"]3520[/TD]
[TD="align: right"]3978[/TD]
[TD="align: right"]3348[/TD]
[TD="align: right"]3697[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month7[/TD]
[TD="align: right"]2791[/TD]
[TD="align: right"]3994[/TD]
[TD="align: right"]3832[/TD]
[TD="align: right"]4793[/TD]
[TD="align: right"]2143[/TD]
[TD="align: right"]3931[/TD]
[TD="align: right"]292[/TD]
[TD="align: right"]2153[/TD]
[TD="align: right"]3299[/TD]
[TD="align: right"]2266[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month8[/TD]
[TD="align: right"]3038[/TD]
[TD="align: right"]2215[/TD]
[TD="align: right"]4969[/TD]
[TD="align: right"]317[/TD]
[TD="align: right"]3466[/TD]
[TD="align: right"]2264[/TD]
[TD="align: right"]3017[/TD]
[TD="align: right"]1249[/TD]
[TD="align: right"]4419[/TD]
[TD="align: right"]3419[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month9[/TD]
[TD="align: right"]431[/TD]
[TD="align: right"]4721[/TD]
[TD="align: right"]1756[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]3968[/TD]
[TD="align: right"]1075[/TD]
[TD="align: right"]1026[/TD]
[TD="align: right"]2286[/TD]
[TD="align: right"]657[/TD]
[TD="align: right"]3591[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month10[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]968[/TD]
[TD="align: right"]3310[/TD]
[TD="align: right"]3576[/TD]
[TD="align: right"]4231[/TD]
[TD="align: right"]4037[/TD]
[TD="align: right"]1756[/TD]
[TD="align: right"]3651[/TD]
[TD="align: right"]4339[/TD]
[TD="align: right"]3870[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month11[/TD]
[TD="align: right"]287[/TD]
[TD="align: right"]3537[/TD]
[TD="align: right"]4592[/TD]
[TD="align: right"]3781[/TD]
[TD="align: right"]4821[/TD]
[TD="align: right"]1925[/TD]
[TD="align: right"]4509[/TD]
[TD="align: right"]2107[/TD]
[TD="align: right"]806[/TD]
[TD="align: right"]2401[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month12[/TD]
[TD="align: right"]3053[/TD]
[TD="align: right"]2933[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]4526[/TD]
[TD="align: right"]3086[/TD]
[TD="align: right"]2160[/TD]
[TD="align: right"]710[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"]1469[/TD]
[TD="align: right"]4249[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]cust1[/TD]
[TD]cust2[/TD]
[TD]cust3[/TD]
[TD]cust4[/TD]
[TD]cust5[/TD]
[TD]cust6[/TD]
[TD]cust7[/TD]
[TD]cust8[/TD]
[TD]cust9[/TD]
[TD]cust10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter1[/TD]
[TD="align: right"]6936[/TD]
[TD="align: right"]1979[/TD]
[TD="align: right"]8010[/TD]
[TD="align: right"]6472[/TD]
[TD="align: right"]4214[/TD]
[TD="align: right"]7828[/TD]
[TD="align: right"]7661[/TD]
[TD="align: right"]4652[/TD]
[TD="align: right"]5413[/TD]
[TD="align: right"]8443[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter2[/TD]
[TD="align: right"]8833[/TD]
[TD="align: right"]12030[/TD]
[TD="align: right"]11936[/TD]
[TD="align: right"]8761[/TD]
[TD="align: right"]6275[/TD]
[TD="align: right"]9032[/TD]
[TD="align: right"]8443[/TD]
[TD="align: right"]8244[/TD]
[TD="align: right"]12855[/TD]
[TD="align: right"]3956[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter3[/TD]
[TD="align: right"]6260[/TD]
[TD="align: right"]10930[/TD]
[TD="align: right"]10557[/TD]
[TD="align: right"]5142[/TD]
[TD="align: right"]9577[/TD]
[TD="align: right"]7270[/TD]
[TD="align: right"]4335[/TD]
[TD="align: right"]5688[/TD]
[TD="align: right"]8375[/TD]
[TD="align: right"]9276[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter4[/TD]
[TD="align: right"]5840[/TD]
[TD="align: right"]7438[/TD]
[TD="align: right"]8565[/TD]
[TD="align: right"]11883[/TD]
[TD="align: right"]12138[/TD]
[TD="align: right"]8122[/TD]
[TD="align: right"]6975[/TD]
[TD="align: right"]5884[/TD]
[TD="align: right"]6614[/TD]
[TD="align: right"]10520[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 7"]you can highlight quarter totals red if spend is down and green if up[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]month[/TD]
[TD="width: 64"]cust1[/TD]
[TD="width: 64"]cust2[/TD]
[TD="width: 64"]cust3[/TD]
[TD="width: 64"]cust4[/TD]
[TD="width: 64"]cust5[/TD]
[TD="width: 64"]cust6[/TD]
[TD="width: 64"]cust7[/TD]
[TD="width: 64"]cust8[/TD]
[TD="width: 64"]cust9[/TD]
[TD="width: 64"]cust10[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]month1[/TD]
[TD="align: right"]1179[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]4231[/TD]
[TD="align: right"]923[/TD]
[TD="align: right"]151[/TD]
[TD="align: right"]2872[/TD]
[TD="align: right"]3259[/TD]
[TD="align: right"]2649[/TD]
[TD="align: right"]884[/TD]
[TD="align: right"]2440[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month2[/TD]
[TD="align: right"]4594[/TD]
[TD="align: right"]1213[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]2157[/TD]
[TD="align: right"]2789[/TD]
[TD="align: right"]2655[/TD]
[TD="align: right"]2696[/TD]
[TD="align: right"]1807[/TD]
[TD="align: right"]1818[/TD]
[TD="align: right"]4434[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month3[/TD]
[TD="align: right"]1163[/TD]
[TD="align: right"]601[/TD]
[TD="align: right"]3695[/TD]
[TD="align: right"]3392[/TD]
[TD="align: right"]1274[/TD]
[TD="align: right"]2301[/TD]
[TD="align: right"]1706[/TD]
[TD="align: right"]196[/TD]
[TD="align: right"]2711[/TD]
[TD="align: right"]1569[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month4[/TD]
[TD="align: right"]2151[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]3131[/TD]
[TD="align: right"]2111[/TD]
[TD="align: right"]222[/TD]
[TD="align: right"]4084[/TD]
[TD="align: right"]2971[/TD]
[TD="align: right"]856[/TD]
[TD="align: right"]4711[/TD]
[TD="align: right"]241[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month5[/TD]
[TD="align: right"]4292[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]4772[/TD]
[TD="align: right"]3323[/TD]
[TD="align: right"]223[/TD]
[TD="align: right"]3409[/TD]
[TD="align: right"]1952[/TD]
[TD="align: right"]3410[/TD]
[TD="align: right"]4796[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month6[/TD]
[TD="align: right"]2390[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]4033[/TD]
[TD="align: right"]3327[/TD]
[TD="align: right"]224[/TD]
[TD="align: right"]1539[/TD]
[TD="align: right"]3520[/TD]
[TD="align: right"]3978[/TD]
[TD="align: right"]3348[/TD]
[TD="align: right"]3697[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month7[/TD]
[TD="align: right"]2791[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]3832[/TD]
[TD="align: right"]4793[/TD]
[TD="align: right"]2143[/TD]
[TD="align: right"]3931[/TD]
[TD="align: right"]292[/TD]
[TD="align: right"]2153[/TD]
[TD="align: right"]3299[/TD]
[TD="align: right"]2266[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month8[/TD]
[TD="align: right"]3038[/TD]
[TD="align: right"]2215[/TD]
[TD="align: right"]4969[/TD]
[TD="align: right"]317[/TD]
[TD="align: right"]3466[/TD]
[TD="align: right"]2264[/TD]
[TD="align: right"]3017[/TD]
[TD="align: right"]1249[/TD]
[TD="align: right"]4419[/TD]
[TD="align: right"]3419[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month9[/TD]
[TD="align: right"]431[/TD]
[TD="align: right"]4721[/TD]
[TD="align: right"]1756[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]3968[/TD]
[TD="align: right"]1075[/TD]
[TD="align: right"]1026[/TD]
[TD="align: right"]2286[/TD]
[TD="align: right"]657[/TD]
[TD="align: right"]3591[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month10[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]968[/TD]
[TD="align: right"]3310[/TD]
[TD="align: right"]3576[/TD]
[TD="align: right"]4231[/TD]
[TD="align: right"]4037[/TD]
[TD="align: right"]1756[/TD]
[TD="align: right"]3651[/TD]
[TD="align: right"]4339[/TD]
[TD="align: right"]3870[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month11[/TD]
[TD="align: right"]287[/TD]
[TD="align: right"]3537[/TD]
[TD="align: right"]4592[/TD]
[TD="align: right"]3781[/TD]
[TD="align: right"]4821[/TD]
[TD="align: right"]1925[/TD]
[TD="align: right"]4509[/TD]
[TD="align: right"]2107[/TD]
[TD="align: right"]806[/TD]
[TD="align: right"]2401[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]month12[/TD]
[TD="align: right"]3053[/TD]
[TD="align: right"]2933[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]4526[/TD]
[TD="align: right"]3086[/TD]
[TD="align: right"]2160[/TD]
[TD="align: right"]710[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"]1469[/TD]
[TD="align: right"]4249[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]cust1[/TD]
[TD]cust2[/TD]
[TD]cust3[/TD]
[TD]cust4[/TD]
[TD]cust5[/TD]
[TD]cust6[/TD]
[TD]cust7[/TD]
[TD]cust8[/TD]
[TD]cust9[/TD]
[TD]cust10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter1[/TD]
[TD="align: right"]6936[/TD]
[TD="align: right"]1979[/TD]
[TD="align: right"]8010[/TD]
[TD="align: right"]6472[/TD]
[TD="align: right"]4214[/TD]
[TD="align: right"]7828[/TD]
[TD="align: right"]7661[/TD]
[TD="align: right"]4652[/TD]
[TD="align: right"]5413[/TD]
[TD="align: right"]8443[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter2[/TD]
[TD="align: right"]8833[/TD]
[TD="align: right"]333[/TD]
[TD="align: right"]11936[/TD]
[TD="align: right"]8761[/TD]
[TD="align: right"]669[/TD]
[TD="align: right"]9032[/TD]
[TD="align: right"]8443[/TD]
[TD="align: right"]8244[/TD]
[TD="align: right"]12855[/TD]
[TD="align: right"]3956[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter3[/TD]
[TD="align: right"]6260[/TD]
[TD="align: right"]7049[/TD]
[TD="align: right"]10557[/TD]
[TD="align: right"]5142[/TD]
[TD="align: right"]9577[/TD]
[TD="align: right"]7270[/TD]
[TD="align: right"]4335[/TD]
[TD="align: right"]5688[/TD]
[TD="align: right"]8375[/TD]
[TD="align: right"]9276[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter4[/TD]
[TD="align: right"]5840[/TD]
[TD="align: right"]7438[/TD]
[TD="align: right"]8565[/TD]
[TD="align: right"]11883[/TD]
[TD="align: right"]12138[/TD]
[TD="align: right"]8122[/TD]
[TD="align: right"]6975[/TD]
[TD="align: right"]5884[/TD]
[TD="align: right"]6614[/TD]
[TD="align: right"]10520[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 7"]you can highlight quarter totals red if spend is down and green if up[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]quarter2[/TD]
[TD][/TD]
[TD]cust2[/TD]
[TD][/TD]
[TD][/TD]
[TD]cust5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cust10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]or just list customers where spend is down in quarter 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Scrumpywill]

This is great in a pivot table could you show me this and then show on the graph

many thanks

 

[oldbrewer]

it is not a pivot table - and why do you need a graph - a table with in my example cust2 cust5 cust10 painted red appears to tell you the big picture

 

[Scrumpywill]

So I need to use conditional formatting

 

[oldbrewer]

you do not need to do anything, but would a table with say red highlighting achieve what you want

do you mean down on a rolling 12 months basis ?

 

[Scrumpywill]

Hello I really appreciate your help with this

i have over 1000 customers and I would like to see the sales dropping per customer in 2016/2017 monthly compared to 2017/2018 monthly

 

[oldbrewer]

would tables with "blocks" of customers eg A to D, E to H etc be acceptable ? As you will be looking at 1000 x 12 bits of data....

 

[Scrumpywill]

would tables with "blocks" of customers eg A to D, E to H etc be acceptable ? As you will be looking at 1000 x 12 bits of data....

Sounds great, could you show me a sample