Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show "Calculated Dimension" in Pivot table but it show "Allocated memory exceeded"
anyone have idea?
Might be something like attached.
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.
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 |
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.
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.
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.