Need to hide the column values in BEX query designer for a formula
Im currently working in bex query designer for a particular query where it counts the value with respect to the row values here i need only the overall result of the count instead its displaying all the hits encountered . In order to this i need to hide the column headings of the count value and display only the overall result
Post ur replies which can be helpful for me to solve this
Anshu Lilhori replied
I am unable to understand your requirement fully because the report format is not clear to me but i guess you are getting result rows two three times so you need to display only overall result.
If that is the case the go to rows panel in query designer and select the characterstic and then select the display tab on right hand side and in that resut rows option will be there select always supress.
Please do it for all the charcterstic you are using in the report except the last one.
hopefully it will sort out your issue.