I have a requirement to export a Pivot table to Excel which has few dimensions in the columns. So based on the dimension value and Measure, i have to format the Numbers in Pivot table. For example, i have transaction type as a dimension and the values are NEW, Renewal, Endorsement and the Measures are Count and Revenue.
Now If it is Renewal and Count, the format should me "#,##0.0" and else cases it should be "#,##0.00"
Can some one help me with this. Thanks in advance 🙂