Removing a repeating row for calculation

[kkkumar82]

In  the attached excel for column DaysinQuarter for the rows 19, 38 there are two rows broken by the FiscalPeriod, I need to build a table

with DaysinQuarter Dimension where in I don't want the two values to be aggregated.

for eg,

For DaysinQuarter for 19th,38th row I want to consider only the first row. I achieved it with DaysinQuarter and Fiscal period as dimension

but want it with out using DaysinQuarter.

Attaching sample data and Qvw file.

[sunny_talwar]

Would you be able to share your app may be anonymizing the confidential stuff?

[kkkumar82]

its a QlikSense App, I don't have access to the physical location of it

[sunny_talwar]

May be download the data and create a QlikView app?

[kkkumar82]

The layout is in Qlikview, UI is in Qliksense, let me try what I can give you

[sunny_talwar]

Sounds good