Hello everybody, i have problem with my mdx query... here my data report item total (composed with a and b) A 100 B 200 and i want to change report format like this with separate calculate: item qty_a qty_b A 20 80 B 90 110 thanks you for ur help :) gbu....

Hi, Post the output columns of your dataset and what expression you used to get the above data in the report. Regards, Gopala Krishnan.VGopala Krishnan.V

Hi Hanny, From your description, you must retrieve the leaf data instead of the total in the MDX dataset. However, you need give more details about your mdx query and data retruned by the MDX so that we could do further research. thanks, Jerry