I have following columns in excel “RC level 1.1”, “RC level 2.1”,”RC level 3.1”and RC level 1.2,2.2

[Niharika24]

I have following columns in excel “RC level 1.1”, “RC level 2.1”,”RC level 3.1”and RC level 1.2, RC level 2.2,RC level 3.2

I want to use a column (rc level 1.1+rc level 2.1+Rc level 3.1 ) as filter and column ( rc level 2.2, rc level 1.2, rc level 3.2 ) as rows and count of it with respect to americas, emeia and apac

[Anonymous]

Hi @Niharika24 ,

Could you tell me if your problem has been solved?

What is the data in “RC level 1.1”, “RC level 2.1”,”RC level 3.1”and RC level 1.2, RC level 2.2,RC level 3.2"?

And what do they have to do with americas, emeia and apac?

Please share some dummy data and expected results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Niharika24]

pls refer saved photos

[Niharika24]

how do i attach excel here

[Anonymous]

Hi @Niharika24 ,

You can insert a table in the toolbar, enter some dummy data, or upload some screenshots.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01]

@Niharika24  provide sample data and expected output