Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Is it possible to show the actual value for totals, and not only the text "Total"?
In that case how?
In the example below i want to replace the text "Total" in the City field, with values from the Country field:
I have:
Country | City | Sales |
USA | Chicago | xx |
Joliet | xx | |
New York | xx | |
Total | xx | |
Sweden | Askim | xx |
Hjo | xx | |
Stockholm | xx | |
Total | xx | |
France | Arles | xx |
Bayonne | xx | |
Paris | xx | |
Total | xx | |
Total | xx |
I want to:
City/Country | Sales |
Chicago | xx |
Joliet | xx |
New York | xx |
USA | xx |
Askim | xx |
Hjo | xx |
Stockholm | xx |
Sweden | xx |
Arles | xx |
Bayonne | xx |
Paris | xx |
France | xx |
Total | xx |
I guess i can do something under "Presentation", but how?
Best regards
Mats
this has been posted before but with no joy.
heres the best solution i can come up with.
go to the style tab and check 'Indent Mode' Check Box.
then go to the dimensions tab and expand the primary dimension, in your case 'Country'.
double click on 'Text Format' and enter in the expresion box there
='<B>'
this makes the country Bold.
then go to the Cities and change the label to 'City/Country'
hope this helps
Thank you Sanchez!
With no joy? I am curious...
Hi,
Perhaps not the best solution for your query but a work around what you can do is while loading exclude the data point Total.
The syntax while loading would be as under
Directory;
LOAD
Country,
City,
Sales
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1) where City <> 'Total';
Tank you Umang!
But i think you have misinterpreted the situation.
The files in my example is not something i want to load into QV. It is the output from QV.
I have to distribute statistcal reports from the tables in QV, and want to keep the manual work at a minimum.
Best regards
Are you looking for something like this which exports as under:
Country | City | Experience |
France | Arles | 962.00 |
France | Bayonne | 496.02 |
France | Paris | 706.00 |
France | Total | 2,164.02 |
Sweden | Askim | 923.18 |
Sweden | Hjo | 704.00 |
Sweden | Stockholm | 926.00 |
Sweden | Total | 2,553.18 |
USA | Chicago | 397.37 |
USA | Joliet | 161.00 |
USA | New York | 304.92 |
USA | Total | 863.29 |
Total | 5,580.49 |
That is what i have today. I would like to replace all the values "Total" in the column City, with the corresponding value in the column Country.