Forum Discussion
Aggregate Value
Where am I going wrong ? I want to filter the quantity sold field month wise but its showing me an aggregate value.
Hey nishantr ,
I assume that the Quantity sold and the Start of Month column are from two different tables and that both tables are related by a date column. My 2nd assumption is that one of the columns contains a time part. Removing the timepart (changing the data type not just the format) can resolve the issue.
If not, provide more information about the tables that are hosting the columns you are using in your visual.
Regards,
Tom
parry2k TomMartens the tables do have a relationship , its between Date and transaction date ,also used an inactive relationship . I feel its because of the data type but i checked everything looks correct.