Analysis on data

[AS]

Hi all,

I to analysis this data. Which activity support best in all the column. I'm thinking to use Formula tab but not sure cross tab or Summarize activity can help? I'm confused.

Account	Catergory2	Name	Dec	Nov	Oct	Average of all months	Deviation from the Average	Delta from nov to dec	Delta from oct to nov
10	General	Software			351.66
10	General	Password	239.53	214	207.9
10	General	UK	168	16	171.9
10	Admin	Systems	152	153	155
10	Admin	AA		77	212
10	Admin	BB	282

[atcodedog05]

Hi @AS 

Here is how you can do it. Hope this works for you.

Workflow:

Not sure whats the calculation for Deviation from the Average

Hope this helps : )

[AS]

Thanks this helps a bit. 😊