Showing periods without summary time on Excel365

Options
matthewman
matthewman
in User Experience

Hi,

Excel365 always forces you to select a time period even if it's on rows or columns. How to show all time periods if the saved view does not have time summaries?

Thanks.

Answers

  • SriNitya
    SriNitya
    Options

    can you provide more information.

  • matthewman
    matthewman
    Options

    Per screenshot, it requires you to select a time value but it does not let you select all or multiple time periods per second screenshot (Time summaries were filtered out on the saved view).

    image.png
    image.png

  • SriNitya
    SriNitya
    Options

    You can just select only one Time period, multiple selection is not possible. As Time summaries were filtered out on the saved view its not visible here.

  • PujithaB
    PujithaB
    Options

    Hi @matthewman

    Try to select only one cost Center and check if it makes Time as Non Mandatory selection

Categories