Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1088 Visualizzazioni

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
Abbandona
Post correlati Risposte Visualizzazioni Attività
7
ott 25
30802
1
lug 25
1120
2
lug 25
2755
0
mar 25
1749
1
lug 24
2565