Search results

As for app development - certainly :) it can do dashboards too http://www.sas.com/technologies/bi/dashboards.html Some major companies have a SAS dashboard on everyone's computer with KPIs or cashflows etc etc

Yep - I agree with you re: clumsiness of pivot tables - they're really not suited to that purpose that you have proposed. Personally I'd write a formula to calculate the cumulative totals outside of the pivot table, but linking to the cells in the pivot table eg. e1, e2, e3 etc. does that make...

I am in love with SAS, that's why I make such sacrilegious statements about Excel....

That's a massive model. Just checked the one I'm working on (not WW's, but client's one) out of curiosity, needs 15 spreadsheets, 90 MB altogether, most have to be opened at the same time...... WW, after having had a quick look at your problem, it's easily doable in SAS, any chance you have...

OK, I just spent about 5 mins reading through the thread. I think I know what WW is getting at, but is there any chance you can upload a spreadsheet for me to play with (Rather than have to create my own mockup etc etc)? Otherwise, can't you just do what Belu said, and do that for the monthly...

Yep, I do a fair bit of this in my job, what do you want to do exactly?