MDX Statement that was executed:
SELECT
NON EMPTY [Measures].MEMBERS ON AXIS(0),
NON EMPTY [0D_SALE_ORG].MEMBERS ON AXIS(1)
FROM [0D_SD_C03/0D_SD_C03_Q009]
WHERE ([0D_DIV].[7])
CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE
Result set:
Incoming orders value | Billing value | Returns value | Credit memo value | |
All Sales organization | 194,174,797.58 * | 186,846,004.29 * | 11,899,068.03 * | 8,610,832.16 * |
Frankfurt | 7,551,870.83 EUR | 7,278,661.82 EUR | 205,535.69 EUR | 169,745.46 EUR |
Berlin | 11,445,868.36 EUR | 11,215,095.32 EUR | 291,228.97 EUR | 218,216.68 EUR |
Munich | 22,297,907.43 EUR | 20,821,494.95 EUR | 1,227,705.02 EUR | 1,213,388.94 EUR |
Hamburg | 6,388,127.30 EUR | 6,205,290.09 EUR | 492,882.69 EUR | 490,019.07 EUR |
London | £ 14,984,849.00 | £ 14,569,213.00 | £ 679,660.00 | £ 354,560.00 |
Birmingham | £ 9,504,655.00 | £ 9,272,423.00 | £ 423,060.00 | £ 207,440.00 |
Paris | 29,869,563.66 EUR | 28,069,450.11 EUR | 2,513,570.66 EUR | 1,536,671.01 EUR |
New York | $ 24,722,543.00 | $ 24,109,951.00 | $ 1,574,226.00 | $ 1,547,560.00 |
San Francisco | $ 8,550,079.00 | $ 7,917,756.00 | $ 718,226.00 | $ 718,226.00 |
Toronto | 31,519,421.00 CAD | 30,570,831.00 CAD | 2,497,600.00 CAD | 1,364,400.00 CAD |
Vancouver | 25,598,113.00 CAD | 25,166,071.00 CAD | 1,218,110.00 CAD | 704,710.00 CAD |
Sydney | 1,741,800.00 AUD | 1,649,767.00 AUD | 57,263.00 AUD | 85,895.00 AUD |