Codes are not properly link...

[Anonymous]

Dear All,

In application product code are not showing Sales and Cogs in one line.

Please check attachment 

[prat1507]

Please drag the line next to Product to increase the space of the cell as you do in excel.

Regards

Pratyush

[prat1507]

Ohh, I think I got it wrong, use Sum({1} Sales), Sum({1} COGS).

Regards

Pratyush

[Anonymous]

gwassenaar‌ / All

I wanted to do in Qlivkew it self ...

Why the Sales and Cogs are not showing product in one line...

[prat1507]

Hi Vijay

Because they're not properly linked, if you remove the second and third columns (dimensions) in your chart you'll find sales and cogs in the single line.

Regards

Pratyush

[jonathandienst]

Sales have null values for dimension 2 and 3, and COGs have non-null values in these two fields. You need to align the metrics (Sales & COGs) and the dimensions. So either remove dimensions 2 and 3, or modify the load to provide these values to Sales as well as to COGs.

[Anonymous]

Sir,

You are right but I bring cogs form different db and sales from db. they don't have any relation between two transaction table expect product code .

so how to achieve the same.