How to create region wise sales reports(dynamic)

[#1]

Hi I Have scenario,

Want to create a straight table based on region(More of trellis)

Please find the attached doc for reference can any body help me on this.

Please do the needful

Regards

Thiru

[PabloOrtiz]

Hi, can you attache a example of straight table whit the expected information?.

[johnw]

It's brute force, but I'd honestly just make four straight tables, then use set analysis to restrict the dimension value that shows in each, like sum({<Currency={'USD'}>} Amount). Get one table that looks perfect, then just clone it and edit the expression. That's exactly what I did with a dashboard a month or two ago.

I'm curious if someone knows a more clever method, though.

Edit: And it's not dynamic. If you add new regions/currencies, you have to add new charts. I'm afraid I've not thought of a dynamic solution.

[#4]

HiJohn,

I am also soing the same,But looking for dynamic.

Thiru

[#5]

Hi

Please find the attached  excel  for understanding

[Kushal_Chawda]

Create the Inline for currencies

CurrencySelection:

LOAD * inline [

CurrencySelection

USD

GBP

SEK

NOK ];

Create the Listbox for this CurrencySelection field on front end. Select one currency.

Create the Variable vCurrency on front end to store the selection and pass it to set analysis. Just call field name in Variable like below

=CurrencySelection

Now create the straight Table

Add dimensions needed and add the below expression

=Sum({<Currency ={"$(=vCurrency )"}>}Amount)

Using this approach you will not need to create the 5 different Straight table. Only one table will be sufficient

[#7]

Hi Kushal,

My Requirement is need to create 5 different tables

So need to create That,It's More of Trellis,Please find the attached Excel for reference.

Thiru