Show Data

[pgalvezt]

Hello,

I have a table where I am showing cumulative data. (Pivot Table) I need to show the same table but horizontally. When I try to pivot the table data dissapear.

My formula Expressions are:

rangesum(above( Num(sum(VENTAS),'#.##0')/Divisor,0,rowno(total)))    (Sales)

rangesum(above( Num(Sum(VENTAS),'$ #.##0;-$ #.##0')/Divisor,0,rowno(total)))/Num(Sum(TOTAL VENTAS),'$ #.##0;-$ #.##0')/Divisor  (%)

Input

A

a  1  0.9

b  5  1.3

Output

A

a 1      5

b 0.9  1.3

Thanks!

[robert_mika]

Try to change Above to Before

Missing Manual - Before() and After()

[sunny_talwar · Accepted solution]

Try this out:

RangeSum(Before(Sum(VENTAS)/Divisor, 0, ColumnNo(TOTAL)))

[sunny_talwar]

And RowNo to ColumnNo