Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I need to create a chart item. here are the requirements. I have a Age summary and Status filed. how can I build a pivot table by using these fileds. please could nayone help me.
Hi Amelia.
I'm not sure that I understand what you need, but I'll try...
You should right click in any empty place of the sheet, select New Sheet object, select Chart. You will see a wizard. On the 1st tab (General) select pivot chart and click next. On Dimension tab you should select your dimensions (Status for example), on the Expression tab you should create an expression: sum(Age). click finish.
I hope I understand what you want.
If not, please provide more details...
Thanks,
Anatoly