Problems with application from data source in Excel - in particular "GetCurrentField ... etc etc"

[#1]

Goodmorning everyone,

I am creating an application that analyzes the visits to clients from my sales force.

The analysis I set three types of partners:

Customers;

Potential customers;

Suppliers.

Sheet "General"

I created a group for the pie chart given by 3 types Customers, Potential Customers and Suppliers in Tab size

and in Table Expressions I entered the following formula:

     if (GetCurrentField ([New Group]) = 'customer',

          count ([Customer]),

          count ([potential customer]))

and it seems to work, I added a line like below

     if (GetCurrentField ([New Group]) = 'customer',

          count ([Customer]),

          count ([potential customer])),

          count ([Manufacturer])

and does not represent me any more pie ... why?

Second request .... always in sheet general under the graph in the grid right you can select customers and potential customers, and it seems to work .... even if I add here suppliers do not work anymore.

This first grid separates me the details by type of partner and that's fine but I also want a comprehensive view on the grid right ... someone help me know?

Thank you all in advance.

[swuehl]

An if() function only takes up to three arguments, conditon, then-branch, else-branch. That's why your modification doesn't work. Use a pick/ match combination instead.

[#3]

Hi,

How can I do? you can please make me an example in my file attachment?

Thanks.

[swuehl]

  pick(match(GetCurrentField([Nuovo Gruppo]),'Cliente', 'Cliente Potenziale','Fornitore'),

          count([Cliente]),

          count([Cliente Potenziale]),

          count([Fornitore])

          )