Sum of SubCategory

[Mahadevaraobc]

Hi, I have the following issue Please help,

I have a table with Month, Column A  and Column B

How do i get Column Total and sum that based on month.

[v-yulgu-msft]

Hi @Mahadevaraobc,

You could create some dummy data like what ryan_mayu did to illustrate your requirement.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[ryan_mayu]

@Mahadevaraobc

I think you can just use sum formula. Could you please explain what situation you are in?

Measure = sum(Table3[Column1])

[Mahadevaraobc]

Thank You,

I have some data in Column B, which is subcategory of column A, how can i count many are present and sum the value and show that for month.

[ryan_mayu]

@Mahadevaraobc

Could you please provide more info and elaborate it? It's better to provide some sample data and the result you expected.Thanks.

[Mahadevaraobc]

Hi,
As I don't have sample data let me elaborate the issue
I have month column, column A ( serial no) and column B (part)
Eg . Column A has 10 serial numbers and assuming each serial no has multiple no parts in column B
Now how do I show in a month how many parts were sent for 1 serial number

[ryan_mayu · Accepted solution]

@Mahadevaraobc

I am not sure if I understand your scenairo correclty.

You can use count. If you don't want to count duplicated the parts. You caan use distinctcount

Measure = COUNT(Sheet1[B])

Measure = DISTINCTCOUNT(Sheet1[B])