Is there anyway to omit weekly summary when export or hide weekly summary

Hello, Is there anyway to hide the weekly summary level when export. when i check omit summary it also omit monthly levels 
Select levels to sow is also disabled 

HarishBabu_0-1667380071300.png

 

Best Answers

  • Hi @HarishBabu 

     

    Let me know if below solution works,

    Create a filter in system module to exclude weeks and include days and months and apply it across in your target module to export.


    ManjunathKN_0-1667394748875.png

     

    ManjunathKN_1-1667394796209.png

     

    Ratio summary is Months/Constant for weeks and Weeks/constant for Days.

    Thanks,
    Manjunath

  • Hi @HarishBabu ,

     

    While @ManjunathKN  solution will work there is simpler way to create needed filter when working with time dimensions. Please see screenshots and explanations below. 

     

    With three line items where two are help line items and third one is final filter to use for time dimension. For helper line items formula is TRUE and for first one time is set to days and for second one to months and Summary is set to None. Last one formula is two helper lines combined with OR and summary set to true. 

    pyrypeura_1-1667398771001.png

    This will result in a boolean which is true for days and months but not for weeks. You can use this boolean to filter your view. 

    pyrypeura_2-1667398932284.png

     

    Best regards,

    Pyry Peura

     

     

Comments