Allocated memory exceeded

[#1]

Hi,

I want to show "Calculated Dimension" in Pivot table but it show "Allocated memory exceeded"

anyone have idea?

[#2]

Might be something like attached.

[Gysbert_Wassenaar]

Create a new field in the script using the expression you now try to use as calculated dimension. Then use the new field instead in the chart.

[#4]

Shyamal i don't want to show like this i know pivot table show the data in this format but i want to show like..

Main Work Center	=If([Priority )))	On Time	Delayed	Grand Total
CIVIL		2	4	6
ELEC		50	41	91
ENGP		8	6	14
INST		59	29	88

[#5]

Thank you Gysbert for your answer.

But i cant do this Both dates which are in the Script are coming from different tables and our both table are huge data if i reload again it will take huge time to reload and it will reload schedule to reload after an hour.

[Gysbert_Wassenaar]

If your tables are huge I don't think you have a choice but to calculate this in the script. Create a summary table if necessary. A calculated dimension using date from two huge tables will very likely give you the error you see now. And even if it doesn't performance will likely be horrible.

[#7]

Hi Adeel,

Then you need to do what Gysbert has suggested. Create this column in script and then use it in front end/chart.

The chart is going "Out of Memory" because of the huge calculation being done.