How to make my pivot only display total amount ?

[paulyeo11]

Hi All

May i know how to make the Table 1 , Now is display all the expense items . i need it display only the total amount , so that i can convert the table into line chart to view trend by month.

Meaning the table only have one row , so that i can change to line chart.

in my next post i will attach the QV Doc.

Paul

[paulyeo11]

Enclosed my QV Doc

[#3]

Leave your dimension empty...

[#4]

Remove

=if(Seq>1 and EXP_P='Y' AND  len(Trim($(ColumnDim8)))>1,$(ColumnDim8) & ' ' )

from dimension

[paulyeo11]

Hi Vinod

After i remove dimension , it only display 1 row , but the total amount changes , the total amount wrong.

Paul

[#6]

Hi Paul,

I examined the code and found that your expression is an average, means, you are dividing Amount with $(ColumnDim98). So, when remove the first dimension from the table. it just do the average for the yearmonth but in earlier case it was doing sum