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	1302
Missing Advanced & Multiple Pricelist functions 已解决 pricelists	1 11月 24	1510
Is there a way to modify Pivotview? pivot	1 7月 24	29
Assign pricelists to a group of customers 已解决 pricelists	1 3月 24	3347
[V14] Defining an action to open a pivot with comparision feature pivot	2 8月 23	2155

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！