I have created a pivot table using coding in c#. Please find attached the excel sheet in which pivot table is created. I want to know how can i style the grand total and top row such as to make it similar to the one in next sheet(with excel) i.e. i want to make it “Bold”. Also can you suggest how I can show/format the numbers in the same way as shown in this sheet i.e. currency symbol with brackets.
I would be much obliged if you can help me out in this. Though i have a licence of previous version but here in this case i have downloaded your latest version to check if it meets my requirement and if so then we can purchase this version.
p.s there would be 10 pivot table on this sheet and i have to apply the style on all of them.
Wow, it worked like a charm. Thanks a lot!!
I was wondering if i want to put “-” for cells where there is no entry then what changes i have to make in this number format style:
pvtTable.DataFields.NumberFormat = “#,##0.0”;
Thank you once again, appreciate it!
radhashym:I was wondering if i want to put "-" for cells where there is no entry then what changes i have to make in this number format style:
pvtTable.DataFields.NumberFormat = "#,##0.0";