Conditional calculation NOT based on dimension in a table

[#1]

Hi All

I have a requirement to do a particular calculation as follows :

Source data looks like --

Catalog#	NTA	Customer	Price
ABC123	A	x	12.32
ABC123	A	x	2.4
ABC123	A	y	6.5
ABC123	B	y	8.6
ABC123	B	z	9.2
ABC123	B	z	8.9

I have selections on Catalog# and NTA. I have a button to Show/Hide Customer from the table.

I have to display min Price based on Catalog#, NTA and Customer against Catalog#

So the output I should get

ABC123           $2.4

irrespective of the 'Show/Hide' Customers.

Please advise. Attached is the sample file.

[alexandros17]

Here is your example:

[#3]

Thanks Alessandro but I cant see any difference in the file you provided.

I need the same value , i.e $2.4 against ABC123 even if the customer data is shown.

[#4]

Forum experts pls help. Can Set Analysis be used in this case?

[Anonymous]

In your Straight Table object how about :

• Tab:  Dimension Limits
• Highlight: Customer :
  • Show only: Smallest: 1

[alexandros17 · Accepted solution]

Ok I did not understood what you needed, try now with the example

[male_carrasco]

Please try :

aggr(min(Price), Catalog#)

Best Regards.

Ale.-

[#8]

Bill, that would limit the customer to only one.

Min Price - The lowest of the prices corresponding at Customer level for a particular combination of Catalog and NTA.

If I take the above data set as example, different cases will be as below :

a) Nothing selected in Catalog# and NTA. Click on 'Show Customer'

I want the output to be -

ABC123	x	2.4
ABC123	y	2.4

b) Nothing selected in Catalog# and NTA. Click on 'Hide Customer'

Output should be -

ABC123

2.4

c) NTA = 'A' . Click on 'Show Customer

Output should be

ABC123	x	2.4
ABC123	y	2.4

d) NTA = 'B' . Click on 'Show Customer

Output should be

ABC123	x	8.6
ABC123	y	8.6

e) NTA = 'A' . Click on 'Hide Customer'

ABC123

2.4

f) NTA = 'B' . Click on 'Hide Customer'

ABC123

8.6

Hope this helps.

[simenkg]

Hi Paramita,

We define a "Shadow table" with the minimum price per Catalog#. We do this in a variable vMinPrice defined as:
=aggr(min(Price),Catalog#)

The expression will then be:

$(vMinPrice).

I did not test it for more than one Catalog#, but I think it should work fine.

Regards
SKG

[#10]

Thanks Alessandro