need help!!

Report Inappropriate Content · ‎2013-10-23

Hi ,

Pls find the attached excel ,,,

Thanks

Report Inappropriate Content · ‎2013-10-24

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 · ‎2013-10-24

Another Way is sum with group by with Field .

PFA sample

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

preminqlik · ‎2013-10-24

hi saurabh

PFA

tresesco · ‎2013-10-24

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.

Related Topics