(Summary of this idea: a spreadsheet view, which provides a grid of cells supporting full cell references similar to Excel, etc., for free-form modelling)

Any Luck... in getting the function for my above query?

Rajesh - This example file shows two different ways of doing these types of weighted adjustment calculations;

1.) one option where you import the weights from an outside file and they become a fixed field in the data set (wieghts may be adjusted adjusted on refresh by importing changed values in the separate source weightings file)
2.) another option where the weights are configured as interactive variables, which can be varied inside the same file by file recipients/users.

Depending on the number of category weights and the degree to which they are fixed, either method may be used.

Thanks but I have tried creating with the the subset unque count function for all the columns and it was bit huge function. Please find the same as below but unfortunately when i closed the report and reopen it I got an error message as attached. Please help me to fix/open it as this report took a lot of time to complete.

FYI... I had already started working on this complicated function before I got your solution which you had provided me in our earlier conversation. Attached the formula for your reference after which I got the above error message.

This has been resolved as I have recreated the whole charts again... Please ignore.