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
nagaraj007's avatar
nagaraj007
Icon for Post Patron rankPost Patron
6 years ago

I have 2 tables:

from 1st table i am using Stratergic objective as common and in 2nd table custom column name (same as Stratergic objective) pulling the data using LOOKUPVALUE to get the target in the main table which is table 2.

 

Target is not a measure, but others in the matrix are all measure. I want to show the sum of target in the matrix table which is not showing.

 

2nd table (main table)1st table

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.