Hierarchy fields to plot

[#1]

Dear

I have the following syntax to load a data table, need to prioritize the data to generate an exploratory graph:

LOAD [Point of Care]

      Kind,

      Code,

      Area,

      Province,

      Circuit,

      County,

      Parish,

      Street address,

      Phone,

      Extension,

      Operation,

      Latitude,

      Longitude

FROM

(ooxml, embedded labels, table is [Puntos de Atención]);

The hierarchy should be Area, province, county, parish and point of care, so that the graph will display data for the selected dimension.

If there is some other solution I thank you in advance

[Anonymous · Accepted solution]

Maybe use a Drilldown Dimension Group.

Have a look at this video :   Creating Cycle and Drill Groups

[#3]

A lot of thanks.....

This video explain perfectly my question.....

Pd. sorry for my terrible english...