Hi there,

I have a dashboard excel sheet display costing data using GETPIVOT. Is there any way that I can add a formula to select whether to display the value as millions or billions? At the minute I am doing one or the other.

Thanks