Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
terezagr
Partner - Creator III
Partner - Creator III

Pivot table format change after publishing

Hi all,

I have published my application and have just came across this problem with pivot table formatting after publishing it.

I have set a pivot table formatting and expected the formatting to be the same after publishing…but unfortunately no.

What did happen is:

Original format of the pivot table:

Dimension nameExpression 1Expression 2
                       Name3024
Total3024

Format of the pivot table after publishing:

Dimension nameHeader 3
NameExpression 124
NameExpression 230
TotalsExpression 124
TotalsExpression 230

I would not have a problem with it as I know I can just simply move the columns around and achieve the Original format of the table, although I do not want my users to have to do that too…So I would appreciate any advice on how to achieve that the Original format of the pivot table will be the same after publishing the application.

Hope this makes sense. Please let me know if you need any further clarification.

T.

2 Replies
gonzaloruizgonz
Partner - Creator
Partner - Creator

HI,

This probably sound crazy but what happen if you disable allow pivoting under chart properties> presentations?

BR//Gonza

terezagr
Partner - Creator III
Partner - Creator III
Author

Hi,

have not tried that one, but instead I have deleted all QV temporary files and rerun the job in QVMC. This fixed the problem….

T.