Adding Months in Text and Numbered Format Line Items and Numbered Format Line Items Only for FY

Aditya77

Hello Everyone,

I had A and B as text line items and Third and Fourth as numbered line items. I created a logic to add two filters in the grid: one to show only the Third and Fourth items in the FY view and another to show all line items in the monthly view.

In the first image, you can see that we created a Line Item Subset (LIS) for the numbered line items. In the LIS module, with a Year time scale, we used another dimension from our module. In the LIS line item, we set it to "True." For the Month line item, we applied a time scale filter set to "Month" only.

We applied these two filters into grid, achieving the desired result as shown in the second image.