There is no file attached. Could you please add the file if you are still working on this issue?
You're right. I forgot attaching the file.
And yes, I'm still working on this issue. I'd really appreciate your help.
Thanks a lot.
Jonathan Drummey came up with a solution as I was stumped on the Pearson TC calculation when I went to use the method he documents for sub-totals on that page. Jonathan also came up with a LOD method to arrive at the same result and I would use that before the Table Calc but both are in the attached file.
Note that the TC version requires Table Calc versions of the Quantity and Sum measures as well to get the right level of detail with the copy of Order ID in the view.
Thank you to Jonathan!!!
Happy New year
Thanks so much. Both of them work fine. However, following your advice I'll use Jonathan's approach.
One more question, How could I hide all rows but the subtotals?
Thanks in advance.
PS.- Sorry for the delay, but I've been on holydays ;D