need help!!

[#1]

Hi ,

Pls find the attached excel ,,,

Thanks

[#2]

PFA the .qvw file regarding the same...

What I have done is, taken the dimension as "if(code=10,code)" and the other dimension being branchid and desc..

now in the expression, i have taken

Jan : -  sum({1<code={10,20}>}total [jan])

Feb :- sum({1<code={10,20}>}total [feb])

March :- sum({1<code={10,20}>}total [march])

Hope this is what you wanted...

Thanks and Regards

[vikasmahajan]

Another Way is sum with  group by with Field .

PFA sample

Vikas

[preminqlik]

hi saurabh

PFA

[tresesco]

Saurabh,

One request, please try to write a reasonable title when you post a question. That would help others too with similar sort of questions. 'need help!!' - does not really say anything about what you want.