Skip to Content

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

Hide Summation in template

Hi,

I want to hide the values where Hierarchy member is a node for a specific account

for example:

Product, Qty, Price, Value

ProductGRP A, 35, 20, 3500

-- Product 1, 15, 10, 1500

-- Product 2, 20, 10, 2000

ProductGRP B, 20, 35, 2500

-- Product3, 10,10, 1000

-- Product4, 10,15, 1500


Assume that Qty and Price Are input for user and this is a hierarchy

How can I hide from

ProductGRPA the 35 and 20

and ProductGRP B the 20, 35?

Thanks.

Regards,

Former Member
Former Member replied

Dear All,

The issue here is that I have many columns with different accounts.

What I did is:

Legend:

Column R = Product.Calc = Y (return if the Hierarchy member is Parent or not parent)

Column AE is a target column that I want to fill the color based on that

Sub AFTER_REFRESH()

    Dim LastRow As Long

    Dim i As Long

    LastRow = Range("R" & Rows.Count).End(xlUp).Row

    For i = 36 To LastRow

        If Range("R" & i).Value = Y Then

            Range("AE" & i).Interior.ColorIndex = 1 (black)

        End If

    Next i

   

End Sub

I also believe this might be not a recommendable solution since it is VB and can take perfomance issues later on.

I will find another way later on to optimize this solution based on BPC standards using EPMFormatting

Thanks again!

0 View this answer in context

Helpful Answer

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