Last post May 20, 2010 04:35 AM by mikr
May 19, 2010 09:54 AM|mikr|LINK
I would like to SUM(value) but it should be displayed in thousands SUM(value)/1000
(to be more accurate then SUM(value/1000). Is it possible for cross-tab ?
Thanks in advance
May 20, 2010 02:06 AM|jsd24|LINK
Can you prvide some sample data with required output
May 20, 2010 04:35 AM|mikr|LINK
Value for one cell (e.g. sum of quantity in meters) is 3 500 125 and I would like to display quantity [KM] - 3 500
(sum consist of many row so sum should be based on meters to avoid of rounding on each reacord).