Forum Discussion
MATRIX, Missing Data on Column Subtotals
Without seeing the model I am just guessing, but a few things I would be looking at;
Which table are the hours in? Based on what you have provided I am guessing 'All Activity AllNodes' table.
If that is correct, have you created the rate lookup column in the 'All Activity AllNodes' table? And if so, does each row have a value that is not blank?
If each hour line has a coresponding rate value then a sum function should work as long as the fields being added to the visual have appropriate relationships to the 'All Activity AllNodes' table.If there are blanks in the rate column you will need to troubleshoot why i.e. which combinations of Team, Department and Level are not pulling a rate. Verify the rate exists (which it sounds like you have done already). When looking LOOKUPVALUE in the past I have had small spelling descrepancies mess the whole thing up too.
Without seeing the model I am just guessing, but a few things I would be looking at;
Which table are the hours in? Based on what you have provided I am guessing 'All Activity AllNodes' table.
If that is correct, have you created the rate lookup column in the 'All Activity AllNodes' table? And if so, does each row have a value that is not blank?
If each hour line has a coresponding rate value then a sum function should work as long as the fields being added to the visual have appropriate relationships to the 'All Activity AllNodes' table.
If there are blanks in the rate column you will need to troubleshoot why i.e. which combinations of Team, Department and Level are not pulling a rate. Verify the rate exists (which it sounds like you have done already). When looking LOOKUPVALUE in the past I have had small spelling descrepancies mess the whole thing up too.
It took me a while but once all the rows with missing RATE assignation where clean the SUM funtion shows the totals.
Thanks!