I believe a simple if else statement should work.
If dimension = $ then fact with dollar
else if dimension = % then fact with percentage.
thanks for your response.
I tried to write the same logic but there is a logic behind sum and avegare which are getting aggregated and creating differences.
I can send you a sample workbook if you want to.
yes sample workbook will be great.
Can I send the sample onto your gmail id?