Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am attaching one sample excel file in that 100 policies are given with their Policy Term and their Product Type.
I just want to know the Average Term for that Product Type..I able to manage to get the answer for (Number of Policies * Term)..but how to find the Average Term segment wise and One summary Table...That I am finding difficult..
1st Requirement is Total 6 Tables are required..
2nd Requirement is Only One Table required which is a summary out-put of this 6 Tables..
In a excel sheet I have put exact calculation and given The Two Requirements..
Please help as I finding little bit Tricky.....
Thanks in Advance..
please post sample app to show how far you have come.
thanks
regards
Marco
Can you provide row data or a sample app?
I think it is not that complicated what you wanna going to achieve...
you can make the calculation(calculate the Average with the group by Dimension ) in script side and make use the measure, dimension in the chat to get the Average required.
Ex:
In the script side:
Dimension name: Product_type
Load
- - - - -
(Number of Policies * Term) / Total NOP as Avg
- - - - -
Group by Product_type;
In the front side, use the straingt table and add the dimension as product_type and in the measure use the "Avg".
It will show as you required the document.
I hope it helps you.
Thanks
Kumar
Hi,
Below attached is the application. In that I able to figure out row level Averages but how to take average of a Total that I don't know also working of II second table also little difficult for me.
Thanks in advance for your help.
Hi,
Below attached is the application...Average of the Total and II requirement I am finding difficult.
Thanks for your help.
Maybe like
=Sum(Aggr(Count(DISTINCT {<Product_Type = {'Ulip'}>} Policy_Number)*Policy_Term,Policy_Term))
/ Count(DISTINCT {<Product_Type = {'Ulip'}>} Policy_Number)
Hi Swuehl,
Thanks... exactly the way I want.
Please mark the solution as correct that answered your question .
Thanks
Regards
Marco