How can I get data into a pivot table in Sales Products Pricelists???

Question

Pivot table icon doesn't show when you select Sales > Products> Pricelists.
I can export to excel the price list however they appear in one column. How do I get Products and categories on the Y axis and different prices lists appearing in there own column on the X axis in excel so I can compare prices at a glance as well as using conditional formatting.

Feryial Mangou · Answer

1. Activate developer mode in settings
2. Go to your required menu (Sales > Products > Pricelists)
3. Click on the "little bug" that has appeared in the top right corner next to Chat
4. Click on edit action
5. In the field "View Mode" add pivot
It should look like this: tree,kanban,form,pivot
Make sure there is a comma and there are no spaces!
Save & Refresh

相關帖文	回覆	瀏覽次數
Tiered discounts 已解決 pricelists	1 4月 25	1305
Missing Advanced & Multiple Pricelist functions 已解決 pricelists	1 11月 24	1517
Is there a way to modify Pivotview? pivot	1 7月 24	29
Assign pricelists to a group of customers 已解決 pricelists	1 3月 24	3349
[V14] Defining an action to open a pivot with comparision feature pivot	2 8月 23	2172

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！