Forum Discussion

nagaraj007's avatar
nagaraj007
Icon for Post Patron rankPost Patron
6 years ago

Unable to display Total in Matrix

Hello All, I have added one column named TARGET to the MAIN TABLE from other TABLE using LOOKUPVALUE (formula is also shown), how ever when i put the value in table matrix i am unable to get the TOT...
Need Help
Show and Tell
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi nagaraj007,

This might be related to aggregation. I find that when I set like below, it won't sum, you could check it

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nagaraj007's avatar
nagaraj007
Icon for Post Patron rankPost Patron
6 years ago

Hi Zoe,

I did that, now the problem is Target is getting summed up based on Custom, but i want lookupvalue to take 1 item as 4440 and make others as 0. That would solve my problem, as its getting summed up of the same custom column which is wrong.

 

Based on custom name it should take only 1 item and make others 0.

 

Could you please help me to fix this issue, it would be of great help.