Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this out:
RangeSum(Before(Sum(VENTAS)/Divisor, 0, ColumnNo(TOTAL)))
Try to change Above to Before
Try this out:
RangeSum(Before(Sum(VENTAS)/Divisor, 0, ColumnNo(TOTAL)))
And RowNo to ColumnNo