Would you be able to upload your workbook with sanitized data? This would help us get a feel for the problem.
One approach I use is to start with a cross tab representation first just to validate that calcs and compute-using-by are working correctly.
Will try putting some sanitized data. But it may take some time. You could easily replicate it using superstore data.
With regard to trying it on a crosstab.Tried that. Spent two hours. Ended up more confused.
Sent from BlackBerry® on Airtel