Calculated Items/Aggregated Items giving 'Too much data' error

[Oscarboots]

Hi Forum,

I have a field that calculates the count of products using SUM, I then add another field that gives me the % of total for each.

When I add an aggregated calculation to do another calc, I get the 'Too much data' error.

Obviously the solution would be to use less data but there isn't that much (about 50 Products) data & I'm surprised that this affects VA.

Has anyone else had the same issue & found a way around it?

Thanks

[Oscarboots · Accepted solution]

I've found that adding each Crosstab table that holds the calcs to a Container alleviates the issue.

I had three Crosstabs inside one Horizontal container. D'OH ...

[justin_sas]

Hey Oscarboots,

Any chance you post pictures of what you are doing?

We are having some spam issues so if you can't, please follow me and send me a direct message with the attachments.

Thanks,

Justin