Hi Team ,
I need to create below structure in BEx.This is to show a cross table in design studio app.Query should have top 3 rank based on total .
I have created 3 selections for countries and 2 formulas for Total and Total % in Key figure structure .
Total % =%RT Key figure .(Total / overall total)
Now to get the total and Total % in Row footer , I thought of creating structure with those 2 .But structure will populate 2 rows in the table body too.
I need only in footer .Even I tried with calculate singles values as Hide , but null values can't be removed from DS cross tab .
Please share any idea .