City, Agent Name, GC Code, Product, Business_Type are in Dimension.
In product--> Motor, Health, SME are the field-values.
In Business_Type --> New, Renewal field-values are there.
I want to add new for all products also I want to add renewal for all products.
I had tried do it in pivot table--> presentation tab --> partial sum, however I got the total for Products, I dint get total_New for Products, & total Renewal for Products.
Please refer the attachment below.
Thanks in advance.
Message was edited by: shruti sarkate
You need to use Island table and that you have to create Pick(....) as dimension to get all values in to single column and these are constant not dynamic..
Devarasu is trying to help you. I would repeat a quote from the link here:
"Asking the right questions takes as much skill as giving the right answers." - RobertHalf
And I have seen that in most of the cases asking the right question (read it - asking in a right manner) play a very vital role - if you get your answer fast or not or even not at all. The problem is, when we post a question here for help, most of the details or contexts we miss out to put here since those remain there in our mind ( and subconscious mind expects it to be known by others too). Therefore, people here to help us out actually keep questioning for details and context. For one it might seem irrelevant, but it might not be so.
Please try to explain you requirement/issue a bit more and possibly with context and sample qvv to work on or look into.