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]

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

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

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

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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