Deals by Product category

Hello Pipedrivers!
I wish I could have a report of the deals in a certain period aggregated by product category.
Category is the only way I've found to discriminate one line of products from another.

Example
Deal 1
Product Cat A 10€
Product Cat B 20€

Deal 2
Product Cat B 20€
Product Cat C 30€

Result
Cat A 10€
Cat B 40€
Cat C 30€

Thanks in advance

0
0 votes

· Last Updated -

Comments

  • Mike van der Valk
    Mike van der Valk Posts: 4,059
    2500 Comments 100 Likes Third Anniversary 5 Answers
    PRODUCT MANAGER
    edited February 2022 #2

    Hi @Alessandro 

    Unfortunately there's no default filter in the report yet for product category. I've added a "feedback" tag to your post to let our team know about your suggestion.

    In the meantime the only solution would be to use third party reporting apps or export the data via API or spreadsheet and create your own reports.

  • Alessandro_25353
    Alessandro_25353 Posts: 3
    edited January 2021 #3

    Hi @Alessandro 

    Unfortunately there's no default filter in the report yet for product category. I've added a "feedback" tag to your post to let our team know about your suggestion.

    In the meantime the only solution would be to use third party reporting apps or export the data via API or spreadsheet and create your own reports.

    Hi @Mike van der Valk ,
    thank you for your reply.

    Immediately after posting, I saw other posts on the same topic (RTFM :D).

    Someone mentioned a workaround which basically suggests to include category into the product name, but still, I'm not able to filter by more than one product.
    I supposed "is any of" filter could accomplish that but it always let me select only one product.

    Is it possible?

    Cheers

  • Mike van der Valk
    Mike van der Valk Posts: 4,059
    2500 Comments 100 Likes Third Anniversary 5 Answers
    PRODUCT MANAGER
    edited January 2021 #4

    Hi @Alessandro 

    Unfortunately there's no default filter in the report yet for product category. I've added a "feedback" tag to your post to let our team know about your suggestion.

    In the meantime the only solution would be to use third party reporting apps or export the data via API or spreadsheet and create your own reports.

    Hi @Alessandro 
    With that workaround you should be able to add multiple like this:
     

    image

     

     

  • Alessandro_25353
    Alessandro_25353 Posts: 3
    edited January 2021 #5

    Hi @Alessandro 

    Unfortunately there's no default filter in the report yet for product category. I've added a "feedback" tag to your post to let our team know about your suggestion.

    In the meantime the only solution would be to use third party reporting apps or export the data via API or spreadsheet and create your own reports.

    Ok got it.
    Thanks.