Pre define view on excel

Question

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

BusinessMTDQTDYTDRetail   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.

NITESH_KUMBHARE · Answer

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

Qiu · Answer

@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.

0419-Nitesh_Kumbhare.yxmd

danilang · Answer

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