Hi,
i have a query subject with the below columns Store_region,store_account,Total_sku,day_key and which is joined to time dimension with day_key i am getting the correct results as expected in Fm but when i drag the same columns with Store_region,store_account,Total_sku,[timedimension].[date] i am getting the wrong results my values are summed for store account and showing this is wrong.
When i put auto group and summarize property it is showing correctly.
Can i know what is the mistake in the report structure is there any work around with determinants.
Thanks,
TGS