Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ

Is there any way to list products and its pricelist value like below?

"Product"    "PricelistA"  "PricelistB" 
PrdA $100 20JPY
PrdB $200 40JPY
Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi,

Steps:

1. Open Sales-> Reporting->Sales

2 . Switch to Pivot View.

3. Put Product on rows.

4. Put the Pricelist on columns.

5. Add the Fixed Price measure.

Result: exactly the format you described, with products in rows and multiple pricelists as columns.


Hope it helps.

Ảnh đại diện
Huỷ bỏ
Tác giả

Thank you for your great support. It meets my requirement.

With this approach you will see only products which has been sold, not the whole products list.

Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 8 25
2190
1
thg 7 25
1147
1
thg 7 25
889
1
thg 2 25
1996
0
thg 1 25
1375