Hi Experts
I create a query based on 0TCT_MC23,acctually I want get the total records last 30days. So I creat a restrict key figure RKF_TOL_RES_30 based on 0TCTRECORDD and variant 0DAT range (from -30 to 0) . But I got the result like below table, seems Records Last 48H is ok but can't get the total number records last 30 days. Could you give hits on it? Thx a lots.
InfoPackageID
0TCTIFPAKID
RequestID
0TCTREQSID
Records Last 48H
0TCT_MC23_RK204
with 0I_48CTS
Records Last 30Days
RKF_TOL_RES_30D
0TCTRECORD
with variant 0DAT range(-30 - 0)
Records
0TCTRECORDS
A 111111 1 1 222222 2 2 333333 3 3 3