pivot table

[#1]

hi all , i have the data coming  from jan to dec , but i have to show the dta from july in pivot table  How?

[robert_mika]

Look for Dual function

How to use- Dual()

[settu_periasamy]

Try to do this in your set expression.

If it is static,

=Sum({<MonthNumber={'>=7'}>}Data)

[gautik92 · Accepted solution]

=Sum({<MonthID={'>=7'}>}Data)