Totals do not adjust to liquid variables in derived table

[Eugen_Bondarchi]

Hey there!

I have faced with issue when providing liquid variables in a derived table and running Totals, then Totals query did not adjust to the query in a grid.

A part of LookML:

SELECT
          {% if flight_media_details_base._in_query %}  flight_media_id, {% endif %}
          {% if placement_details_base.placement_id._in_query or placement_details_base.placement_name._in_query %} placement_id, {% endif %}
          {% if daily_core_stats.demand_date._in_query %}  demand_date, {% endif %}
          impressions
        FROM
        (
         SELECT
            {% if flight_media_details_base._in_query %} DCS.flight_media_id,  {% endif %}
            {% if placement_details_base.placement_id._in_query or placement_details_base.placement_name._in_query %} DCS.PLACEMENT_ID, {% endif %}
            {% if daily_core_stats.demand_date._in_query %} DCS.DEMAND_DATE {% endif %}
            sum(DCS.impressions) impressions
        FROM TABLE1 DCS
        WHERE {% condition daily_core_stats.demand_date %} DCS.DEMAND_DATE {% endcondition %}

And that what I see actually when demand_date dimension in a grid:

WITH cte AS (SELECT
                flight_media_id,

                demand_date,
              impressions  
           FROM
            (
             SELECT
                 DCS.flight_media_id,

                 DCS.DEMAND_DATE,

                sum(DCS.impressions) impressions
            FROM TABLE1 DCS

…
…
…
– sql for creating the total and/or determining pivot columns

WITH cte AS (SELECT
                flight_media_id,
              impressions 
            FROM
            (
             SELECT
                 DCS.flight_media_id,


                sum(DCS.impressions) impressions
            FROM TABLE1 DCS

There is no demand_date dimension in sql for creating total.
Can anyone help with this ?