Pre define view on excel

[NITESH_KUMBHARE]

Which tool I have to use to get table like below:

Business	MTD	QTD	YTD
Retail
Corporate
Finance
Risk

In my input data, above shown details are not available.

I want to create table like above, after creating above table view- I will fill values in MTD, QTD & YTD using my input data.

Pls help cheers.

[danilang]

Hi @NITESH_KUMBHARE 

There are potentially quite a few ways to do this, but the specific method to use depends on the structure of your input data.

Can you provide a sample of your input as well as what the output should look like?

Thanks

Dan

[NITESH_KUMBHARE]

Hi @danilang

Thank you for your revert.

I have created a small sample input & output in attached excel.

Output is a table which I want. I have also added a formula in MTD to get number from Input

[danilang]

Hi @NITESH_KUMBHARE 

Thanks for the sample.  However, there's still some missing information.  How do the clusters in your input, M500, M900, etc map to the Business categories in your output, Retail, Corporate, etc 

Dan

[Qiu]

@NITESH_KUMBHARE 
As @danilang  has adviced, the missing puzzle piece is the mapping between your "Bussiness" column in the output and the "Cluster" column in the input.

Assumming a mapping exists, then a Cross Tab tool can help.

[NITESH_KUMBHARE]

Hey thank you for your rveret.

Instead of creating mapping, do we have any option where i can add Business manually?

You can see a Business as Corporate in my output.

Again I have subpart of Corporate like

Corporate exposure greater than 500m

Corporate exposure between 100m to 500m

Corporate exposure less than 100m 

Above 3 subpart of corporate is not available in my input, I need to add them manually.

We use Report text tool to give heading , same way do we have any other total to give label row wise