콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다

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

"Product"    "PricelistA"  "PricelistB" 
PrdA $100 20JPY
PrdB $200 40JPY
아바타
취소
베스트 답변

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.

아바타
취소
작성자

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.

관련 게시물 답글 화면 활동
2
8월 25
2189
1
7월 25
1144
1
7월 25
889
1
2월 25
1990
0
1월 25
1371