The closest analog of a FIXED LOD dimension field
(in the Pre-LOD era of 8.x) is a Conditional Set.
Your [Sales Decider] logic is used to build a Condition.
And the VizLOD granularity of Product ID / City / Year
is used as the Set member Dimensions (via concatenation).
The resulting Set allows to avoid the [Sales Decider]
Discrete Aggregate's Ignore in Table Calculations trap.
Please find the attached.
sales pct_YF.twbx 398.0 KB
Thanks for your help..I cannot find the attached.Could you please attach again.
Once again, Big Thanks
Please go to this thread in the Forum
(via link in your email) and find the attachment
as a link with a Clip icon (at the lower left).
Thanks Yuri! Awesome solution.