Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatting help

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 .

Not what you were looking for? View more on this topic or Ask a question