Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
to format a pivot chart with one dimension (Amount Type) on rows and two dimensions (Year and Month) on columns I need to insert an empty row to act as a separator with fe gray background colour. For this empty row I have set a particular value for the Amount Type dimension.
Any suggests in order to add a conditioned formatted empty row, please?
Thanks
In the Dimensions tab of the chart properties, Click the "+" next to your dimension name. Then select "Backgound Color" and press the edit button.
Correction to my earlier example. There is no "grey()" function. Use a valid function name 🙂
Not sure your exact requirements, but how about creating an expression formula:
=''
or
=null()
Hi,
I've partially solved by load a dummy row with fictitious values for my dimensions, but now I'd like fe to format the background of this dummy row added, without affecting the background of other rows.
Thanks
You should be able to do something with the Background color property in the Dimension. Click the plus next to the Amount Type dimension.
=if([Amount Type]='mydummy', grey())
In the pivot chart I cannot see any background colour properties for a dimension.
Thanks
In the Dimensions tab of the chart properties, Click the "+" next to your dimension name. Then select "Backgound Color" and press the edit button.
Correction to my earlier example. There is no "grey()" function. Use a valid function name 🙂
Ok, thanks, I've solved.