Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
734 Zobrazení

Hello,

i want to summarize the revenues of product categories. Using the pivot table of the sales repoting, gives me all product categories with the correct ammount of sales.


But is it possible to sum values just for the top categories.

Example:

.../sales

.../sales/B2C

.../sales/B2B

.../service

.../service/B2C

.../service/B2B


I would like to sum all revenues for categories that contain either sales or service.

Which formular is suitable for that? SUMIF maybe?


Thanks for the help.

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
čvc 25
295
2
čvc 25
1982
0
bře 25
1081
1
čvc 24
1942
7
čvc 24
25191