Showing periods without summary time on Excel365

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

  • can you provide more information.

  • 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).

  • 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.

  • Hi @matthewman

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