Main category and sub categoy in the same column

[Anonymous]

Hello!
I have a table that looks like this:

Main Cat1	aaa	bbb
Main Cat2	ccc	ddd
Sub Cat2.1	eee	fff
Sub Cat 2.2	ggg	hhh
Main Cat3	iii	jjj

And i would like to split them up to make independant calculations with sub categories and main categories. 
Do you know how to do that?

Thanks!

[SpartaBI]

@Anonymous first of all you don't have to split them in order for calculations will do whatever you want them to do 🙂
Anyway, you can create 2 calculated tables:

CategoryTable = 
	FILTER(
		'Table',
		SEARCH("Main",'Table'[A],1,BLANK()) > 0
	)
	
	
SubCategoryTable = 
	FILTER(
		'Table',
		SEARCH("Sub",'Table'[A],1,BLANK()) > 0
	)

If this solved your question please mark this as a solution. Appreciate Your Kudos 🙂

[ribisht17 · Accepted solution]

@Anonymous ,

What is the differentiating factor, how can you detect when this is a category/sub-category?

For example, if you have a column say Flag, then you can create a different column based on Flag='Yes' 

You will have a new column like

Check_Cate_Sub-Cate

Category

Sub-Category

Category

so forth and so on......as you said independent

Now make use of Pivot to see those as headers(Category/Sub-category)

Regards,

Ritesh