I have a question regarding two different sheets. I need an explanation for this if possible, please
In sheet 1 : "I have used a fixed LOD (Level of Detail) calculation in the form of
{ FIXED [Invoice No]: SUM([Quantity])}
and named it 'Invoice Total Quantity.'
In sheet 2: I simply dragged and dropped 'Quantity' in columns and 'Sales' in rows.
I thought it should give the same answer, but it gave me two different answers. Can anyone explain to me why?
Screen shot 1 (calculated field)
Screen shot 2 (Sheet 1)
Screen shot 3 (Sheet 2)
good morning @Mohammed sheeth K K
your lod says to create a dimension like bins based on the total quantity for each invoice number and save it so I can use it later like any other dimension - to categorize (group) records -
you then place it in 2 different charts the have a filter applied (which you did not share) that affect the overall chart but not the lod (they are dimension filters like filter our records that would drop into the bins you created with the lod) and plot that against some sort of tc (that you did not share) based on sales -
those other calculations and filters are affecting the results but we would need to see the twbx to say more - see https://jimdehner.com/2022/01/29/6-types-of-filters-and-how-they-affect-the-data-table/ for when and how filters are applied - also see https://jimdehner.com/2022/07/23/fixed-lods-and-how-they-are-affect-by-filters/ which is specific to lods
