i just got a partial answer
for table Main2
where i did groupby with respect to 1 dimension
the values are matching by changing the expression as
but this is not working for another table i.e Main table where
i used groupby with respect to three dimension
how to get an average for three dimension (grouped value)
Thanks Gysbert, for your response ..i have been struggling to get a correct answer fro 2 week .......
with your reponse i came to know the right spot to look at .......great help ..reallly appricate it
now it's working fine ..
i stored the table into a qvd and again used distinct for key field ....
now all my values are uniques and working fine for expression sum