I have a drill down dimension.Ex. Country,city,District , store
My measure is sum (total <dimension> sales )
Here how do i change the dimension value according to drill down.
Please help me..
You might need to add an index number to the function. Take a look at the qlik help pages.
If it still doesn't work then I think I have an example on my PC that I will have access to later tonight or tomorrow that I could post here. Please let me know.
This expression will calculate total excluding the dimension in the second column.
See attached QVF file