Pivot table with conditional expressions

[#1]

Hi Experts,

I have attached a sample qvw.

i did inner join of two tables in the script.

we have different products & different branches.

i need to count the no. of products sent from one branch to wholesale store on a particular day and again how many of the same product is returned back to the same branch in the next 7 days.

In the attached file, i have three tables.

first two tables- detailed & test view are showing correct values. but the summary table is not correct.

i dont know how to correct the expressions.

Also i need to correct the charts as well.

please help me on this.

[hic]

I suspect that the inner join causes record duplication. Remove it and see if that makes a difference.

See also To Join or not to Join

HIC

[#3]

Hi henric,

i tried removing the join, again i m not getting correct values other than the two tables i mentioned.

Pls give some other suggestions.

[nagaiank]

Did you try using 'Concatenate' instead of 'Inner Join' ?

In your inner join, only field common to both tables is PNO.

[#5]

i cant use concatenate. i purposely did inner join as per the requirement.

no prob on the joins.

i need to correct the table & charts.

in the first two table dimensions, i have given conditions for To Date & RE order no. this is because of the requirement.

[#6]

Any other suggestions pls