Hi Hui,
Yes i want to calculate Field as said in my Previous Question i have even uploaded the sample file for the same.
Actual file will be updated with the fresh data every month.
i want it be shown as Formula or VBA which will help me to say how that was calculated.
you can try with...
How do i edit a inserted Blank Column in Pivot Table .
Example :
P1 Tickets
Month Out of SLA WithinSLA OLA Per %(Blank Which is inserted) P1 Total
Jan 3 7 10
Feb 5 10...
hi i have create a file with sample data and i have created a Pivot tables and charts for ABB customer, the same pivot tables and Charts need to be created for CNN. BCC... etc.
Note : i have only created 2 Pivots and chart but actual pivot and Chart in original data(cannot be shared) are more...
Hi Kaushik,
Sorry i can not upload those file which carries very sensitive data. here is my Requirements
1. I create same pivot tables and charts for all the 20 customers.
2. I Need this same pivot tables and charts in different tabs/sheets of a same workbook but 1 to 20 customer 1 in...
Hi,
I have a tickets Report for say some 20 customer of 10 months and one single Heading for all, and i want to create similar Pivot tables and chart for all the Customer in different workbook (TAB)in same excel file.
Can some one please help me on this ?
Thanks in advance.
Hi,
I have followed the exact step as above.
But while doing below step
=chtsel i get a error saying "Reference is not Valid".
Request you help here
Thanks in advance