Hi I need to calculate a value on table on the report but the 2 Columns came from different queries.
so I create a table and I assign the data key from “Query 1” and I add the first column to the table so far so good.
but when I add the second column from a different query" Query 2" the value of all the rows on the second column have the same value (same as the first row of the second column)
I’m sure both columns have the same number of rows.
I try to solve this with the group table but I have the same problem.