Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm looking to create a pivot table over months that sums a field called "ukmpsmr_risk_prem_by_uw.PBU_NET_USD" to create an accumulation.
Easy?
instead of above try before
rangesum(above(sum(ukmpsmr_risk_prem_by_uw.PBU_NET_USD), 0 , RowNo())))
like this
That works if I have Month as rows but i want Month as column headers.
instead of above try before
Superb and changing RowNo to ColumnNo it's worked a treat, thanks
This is a really stupid question I'm sure, but I require a total column too (which i know will be the same as the most recent date but I'm being asked for it). Surely i can add total to a pivot?