chart help. urgent plsssss help

[#1]

Hi Expert,

i have attached the sample qvw.

i have two tables in that as per my requirement.

but two tables showing different values on expression.

i have selected a particular product for example.

i need to total products going from location1 to location2 on one day and how many returned from location2 to location1 from next day.

but both tables should have same values.

Please help me on this.

[Clever_Anjos]

You application has only one table and no graph.

Maybe you attached before saving

[Clever_Anjos]

[Anonymous]

curious effect

with fit zoom to window you wull see the two tables

[#5]

Click on that Search object. You will see two tables

[cjohnson]

Perhaps this is a silly question but why are the AGGR's needed in the first table? Can you not have expressions as follows:

SUM(ORDQTY)

SUM(REORDQTY)

[#7]

Hi Camile,

if i remove the aggr in the first table, it is showing wrong values as like second table.

the first table value is correct.

i want the same values for the second table.

pls help me to solve this

[cjohnson · Accepted solution]

Hi,

I'm not sure what the intent is (I'm not sure what you're actually trying to show), but if it's simply trying to get the two tables to match please see attached.

If you remove the external SUM from your expression in the straight table it will match the value of your pivot table as shown below:

Would you mind elaborating more on the intent of this?

Thanks,

Camile

[#9]

thanks a lot camile