About shreyashree

Hi @ManjunathKN I am not sure about the use case to which you are trying to apply this solution. But I could achieve this using two additional line items (Numerator and Denominator) in which you will calculate the expected values based on condition which checks if it is time summary or non-time summary. This will be a little confusing, so please bear with me. 1. This is the data which I will be using as numerator and denominator of the ratio summary based on Time and Non-Time (Other) dimension. 2. The logic to determine Time and Non-time dimension is as follows: This is how it looks like in the module - Time checked in the time summaries and Other checked in Non-time summaries: 3. Then create the Numerator and Denominator line items with Formula summary which are calculated based on the above booleans. 4. Set the Numerator and Denominator line items in the Ratio summary. The highlighted values show the ratio summary calculated. Let me know if this works for your question. Thanks. ... View more

Hi @Yueyi , The filter is disabled if you use show/hide or any other filters on the dimension in the saved view. So use Show all columns by right clicking on the columns in the saved view or try removing any filter if you have applied on the columns. That should work for you. ... View more