Forum Discussion

BartDekeyser's avatar
BartDekeyser
Frequent Visitor
3 years ago
Solved

SubTotals

Hi ,

 

I have a matrix  visual created using relationships and Lookup. 

 

 

When i remove Child from this visual  The Total * index recalculates as does the index and the total to sums

 

A becomes 310, index becomes 1.4 and the total becomes : 434, that isnt correct. How can i prevent that. 

I want the total to become : 132

 

Extra Information : Parent is a lookupvalue based upon Child. (We have a classification table for these matters)

 

Total and Index are measures, since date_sut has to be the same, date_pub has to be the most recent, so i had to do some recalculations.

 

I have 3 tables : 

 

1 with Child Values, 1 with index values and the third one is the classification table. 

 

Is there a possibility to adjust the total * index based upon the values selected in the visual, rather then summing it.

 

2 Replies