Expression col outside of group

[#1]

Hi All,

struggling to achive some functionality. Looks like below.

                                                                       Group Dimension -------------------------------------------------->

Dimension 1  ¦  Dimension 2 ¦ Col Expression1 ¦ Col Expression2 ¦ Col Expression2 ¦ Col Expression2

So basically, i dont want Col expression1 to be grouped. Possible?

[MK_QSL]

May be you can use Col Expression 1 as a Calculated Dimension with Aggr in Pivot Table.

But without looking your sample file or application, difficult to give an accurate reply.

[Gysbert_Wassenaar]

I'm afraid I don't understand what you're trying to do. Can you give an example? Perhaps a mockup of the result in an excel file?

[#4]

sure, the expressions are averages based on a dynamic date range, The grouping effectively provides the detail.

[Gysbert_Wassenaar · Accepted solution]

Ok, you can try using two calculated dimensions for the 12wk Avg and 4wk Avg columns. If you have a Date field then those expressions would look something like this:

aggr(avg({<Date={'>$(=max(Date)-84)<=$(=max(Date))'}>}Value),Supplier,Product)

aggr(avg({<Date={'>$(=max(Date)-28)<=$(=max(Date))'}>}Value),Supplier,Product)

[#6]

Perfect! Thank you Gysbert!