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.
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.
