I have manage to do Blank Column in Pivot Table using Expression ' ' (Space) and
Background & Text Color = RGB(224,224,224) that's fine.
But now I want heading for this Blank Column invisible or greyed out with same colour like RGB(224,224,224).
How to do?
I also want Blank rows after each Total.
Thank for reply but I can't do in script side because I got daily sale transaction linked with other tables.
Is there any thing can I do on report/Pivot table?
I am not sure is this as per your requirements,
but what I understand with you statement
now I want heading for this Blank Column invisible or greyed out with same colour like RGB(224,224,224).
just go to the chart property->
visual cues->select expression ->then at bottom you can see Text option->in front of that you can select text color and background color.
Hope this will help you with your first requirements.
That heading is nothing but your values come from dimension or from expression
if it is dimension values
then go to
dimension tab->select dimension->click on plus sign->set background and text color
as per your requirements
if it is expression the you have same functionality in expression tab.
Hope this will solve your problem.
find attached application
where ever you are creating blank dimension
change there text color and background color to gray.
check enclosed file and if possible share your qvw.