yearly comaparative report by attribute
Summary
yearly comaparative report by attributeContent
Hi
I am trying to build yearly comparative report by attributes.
I have created two attributes
1) contract status - prior YR (with children base,new and lost)
2) contract status - current YR (with children base, new and lost)
and assigned them to dimension "contracts" with as contract status "base", "new" and "lost"
The report will show yearly comparative results between (Base:Base); (New:New); (Lost:Lost) based on the scenario? The contract status FY19 and FY20 is as below:
FY19 FY20
Contract 1 Base Lost
Contract 2 Lost -
Contract 3 New Base
Contract 4 New Lost
Contract 5 New Lost